#Value being returned

[John]

I have the attached formula in one of my cells and it returns a #value, I
want it to return "Blank". It is basically saying if a cell in Detail Input
J12 is less than 0 then multiply it by -1, otherwise leave it blank. And
ensure that the result is rounded by 2 decimal places.

=ROUND(IF('Detail Input'!J12<0,'Detail Input'!J12*-1," "),2)

I have a feeling I have the Round in the wrong place

Thanks

 

[Frank Kabel]

Hi John
in your formula it could happen that you try to round the 'False'
return of your If statement. Try the following:
=IF('Detail Input'!J12<0,ROUND('Detail Input'!J12*(-1),2),"")

I also changed the return of " " (a space) to "" for the false
condition

 

[John]

Spot on again Frank,

Thanks for that,

Rgds

John