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