| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I return "leave cell blank" using IF logic.
You cannot have a truly blank cell if you have a formula in it
Excel does not recognize a Null value. =IF(ISBLANK(D40),"",TODAY() is the closest you can come but is not blank. Gord Dibben MS Excel MVP On Tue, 8 Apr 2008 10:51:02 -0700, tlm1tlm wrote: =IF(ISBLANK(D40),NULL,TODAY()) does not work since NULL is not a function. Tried many combinations but something is always returned when the cell is blank. The column of cells are formated for date. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| To leave a cell blank following an "IF" function | Excel Worksheet Functions | |||
| Return blank for true "if" statement when charting, not 0 | Charts and Charting in Excel | |||
| Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA | Excel Worksheet Functions | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Threaded Mode
