Domenic Wrote:
Try...

=IF(D4<"",D4*0.9*0.9,"")

Hope this helps!


....and it has! Thanks a lot for that. It works on any cell with a
similar problem as well., could anyone explain why this works though? I
thought you'd have to use the 'SUM' prefix before the formula..

thanks again
barry


--
bazza825
------------------------------------------------------------------------
bazza825's Profile: http://www.excelforum.com/member.php...o&userid=33241
View this thread: http://www.excelforum.com/showthread...hreadid=537382