Round function in If statement

[penri0_0]

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

 

[Pete_UK]

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

 

[penri0_0]

Thanks Pete, works perfectly.

 

[Pete_UK]

Thanks for the feedback.

Pete