#Value being returned

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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
 
Back
Top