| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I reference an empty cell in a formula?
Thanks!
"Peo Sjoblom" wrote: It depends, would the cell be the next cell above? =IF(A5="",A4,A5) -- Regards, Peo Sjoblom "srosebed" wrote in message ... Trying to write an IF statement to return one value if the cell is empty and another if not. For example, if the cell is empty, return the value above, if not empty, return the value itself. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
| formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| Can I empty the cell who has formula in it | Excel Worksheet Functions | |||
Hybrid Mode
