| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function/sum function | Excel Discussion (Misc queries) | |||
| How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
Linear Mode
