Thread: If function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
John James
 
Posts: n/a
Default If function


This rounds to 2 decimal places. Is this what you want? Otherwise can
you explain more clearly.

=IF(C4<1,0,ROUND(D4*F4,2))


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531729