| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I return "leave cell blank" using IF logic.
=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
