Need column K to = 0 if J is blank
 

Re Excel 97 -------

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


This is column K:
=IF(J80,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

Need column K to = 0 if J is blank
 

Try this:

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

Biff

"Jack B" wrote in message
...
Re Excel 97 -------

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


This is column K:
=IF(J80,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

Need column K to = 0 if J is blank
 

Biff,

That did it!

Thanks.

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


"Biff" wrote in message
...
Try this:

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

Biff

"Jack B" wrote in message
...
Re Excel 97 -------

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


This is column K:
=IF(J80,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

Need column K to = 0 if J is blank
 

You're welcome. Thanks for the feedback!

Biff

"Jack B" wrote in message
...
Biff,

That did it!

Thanks.

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


"Biff" wrote in message
...
Try this:

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

Biff

"Jack B" wrote in message
...
Re Excel 97 -------

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


This is column K:
=IF(J80,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