Need column K to = 0 if J is blank

  • Thread starter Thread starter Jack B
  • Start date Start date
J

Jack B

Re Excel 97 -------

This is column J, which works fine:
=IF(SUM(E8:I8)>0,SUM(E8:I8),"")


This is column K:
=IF(J8>0,J7-J8,0)

This works fine as long as there is a number in column J (or if column J has
no formula), but it shows #VALUE! if J is blank (but contains above
formula). I want it to show 0 if column J is blank even though it contains
a formula. What do I need to do?


???
Jack
 
Biff,

That did it!

Thanks.

Jack
-------------------------


Try this:

=IF(ISNUMBER(J8),J7-J8,0)

Biff
 
Back
Top