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
|