| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I have a formula in a cell, how can I make it come up blank?
Example, I have the formula e2+e3 in cell e4. I have data in cell e3 but
nothing in cell e2. I want e4 to be blank instead of putting in a zero. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I have a formula in a cell, how can I make it come up blank?
=IF(E2="","",E2+E3)
Basically this does the check. Especially important if your formula has divides. -- Gary''s Student - gsnu200732 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I have a formula in a cell, how can I make it come up blank?
Try this in E4:
=IF(OR(E2="",E3=""),"",E2+E3) Hope this helps. Pete On Jun 21, 1:45 pm, Vi wrote: Example, I have the formula e2+e3 in cell e4. I have data in cell e3 but nothing in cell e2. I want e4 to be blank instead of putting in a zero. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I have a formula in a cell, how can I make it come up blank?
=IF(E2="","",E2+E3)
or =IF(ISBLANK(E2),"",E2+E3) -- David Biddulph "Vi" wrote in message ... Example, I have the formula e2+e3 in cell e4. I have data in cell e3 but nothing in cell e2. I want e4 to be blank instead of putting in a zero. Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I have a formula in a cell, how can I make it come up blank?
Thank you, this helped.
"Vi" wrote: Example, I have the formula e2+e3 in cell e4. I have data in cell e3 but nothing in cell e2. I want e4 to be blank instead of putting in a zero. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to leave a formula cell blank when it has no calculation to make | Excel Discussion (Misc queries) | |||
| make Cell blank | Excel Discussion (Misc queries) | |||
| Can you use a formula to make a truly "blank" cell | Excel Worksheet Functions | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
| Help with formula to make cell blank | Excel Worksheet Functions | |||
Linear Mode
