HI,
Say that your formula is in F97 and you want your formula to calculate
only when a number is entered in D97 then:
=IF(D970,SUM(E96+C97)-D97,"")
or..the shorter version
=IF(D970,E96+C97-D97,"")

in simple terms
=IF(D970,if true, if false)

Hope this helps!
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=474939