| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
simple sum unless blank
simple formula j1-i1 but when I expand down the column I want it to return 0
or leave empty if a cell is blank. Can you help me? -- Cheryl |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
simple sum unless blank
Try this:
=IF(COUNTA(I1:J1)=2, J1-I1, "") -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "Cheryl" wrote: simple formula j1-i1 but when I expand down the column I want it to return 0 or leave empty if a cell is blank. Can you help me? -- Cheryl |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
simple sum unless blank
Try this:
=IF(COUNTA(I1:J1)=2, J1-I1, "") -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "Cheryl" wrote: simple formula j1-i1 but when I expand down the column I want it to return 0 or leave empty if a cell is blank. Can you help me? -- Cheryl |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
simple sum unless blank
This should work for you.
Try this: =IF(COUNTA(I1:J1)=2, J1-I1, "") -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "Cheryl" wrote: simple formula j1-i1 but when I expand down the column I want it to return 0 or leave empty if a cell is blank. Can you help me? -- Cheryl |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
simple sum unless blank
Try this:
=IF(COUNTA(I1:J1)=2, J1-I1, "") -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "Cheryl" wrote: simple formula j1-i1 but when I expand down the column I want it to return 0 or leave empty if a cell is blank. Can you help me? -- Cheryl |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
simple sum unless blank
Hi,
=if(or(i1="",J1=""),"",J1-I1) "Cheryl" wrote: simple formula j1-i1 but when I expand down the column I want it to return 0 or leave empty if a cell is blank. Can you help me? -- Cheryl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple Find Blank row | Excel Discussion (Misc queries) | |||
| Simple Sumproduct of 2 Columns, with some blank cells in range | Excel Discussion (Misc queries) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| simple formula with blank cells | Excel Worksheet Functions | |||
| Make it more simple or intuitive to do simple things | Charts and Charting in Excel | |||
Linear Mode
