Need column K to = 0 if J is blank

[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]

Try this:

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

Biff

 

[Jack B]

Biff,

That did it!

Thanks.

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


Try this:

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

Biff

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Biff,

That did it!

Thanks.

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


Try this:

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

Biff