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