Round function in If statement
 

Hello,

Hopefully a nice simple one for you all to improve your post count! ;)


In this formula
=IF(ISERROR(F21/C21)=TRUE,0,(F21/C21))

where can i insert the Round function to 2 places (i.e. it rounds up or
down with no decimal places)

I can't figure it out.

thanks in advance


--
penri0_0


------------------------------------------------------------------------
penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947
View this thread: http://www.excelforum.com/showthread...hreadid=545427

Round function in If statement
 

Try this:

=IF(ISERROR(F21/C21),0,round(F21/C21,2))
or a slight variation:
=IF(C21=0,0,round(F21/C21,2))

You will also have to format the cell as a number with 2 decimal places
to see them - sounds like your current format is 0 dp.

Hope this helps.

Pete

Round function in If statement
 

Thanks Pete, works perfectly.


--
penri0_0


------------------------------------------------------------------------
penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947
View this thread: http://www.excelforum.com/showthread...hreadid=545427

Round function in If statement
 

Thanks for the feedback.

Pete