View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default 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