Hi,
that is fine working, but the next cell having a formula
=IF(I2="S",CEILING(K2*L2,0.05),IF(I2="P",ROUNDDOWN (K2*L2/0.05,0)*0.05,""))
is getting error.
Any solution?
thanks
nowfal


--
nowfal
------------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=400252