An IFless alternatve

=ROUNDUP(A21,-1)+(A210)*9.99

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Vito" wrote in message
...

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