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
|