All you should need is to add an If Condition to check if the cell is
blank.


=If(A1="",0,Round.......), Where A1 is the cell containing the initial
value, and Round...is your formula for rounding etc...


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=489189