|
|
#1
10-10-2023, 12:30 PM
|
|||
|
|||
Need cell to return NULL if there is a formula in referenced cell
=IF(ISBLANK($T2),"", MAX(0,$T2-TODAY()))
This formula reads column T for a date and counts down to Zero where it stops. There is a formula underlying the date in column T so that even when there is no date, Excel doesn't read the cell as "blank" because of the formula. I've tried ISERROR but I think I got my syntax wrong. I need this formula to return NULL when there is no date in column T. Thanks. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| I want my formula to result in zero if referenced cell = 0, otherwise calculate | Daronovitz | Excel | 2 | 12-21-2022 11:44 AM |
| Filling a formula down a column where only one cell value referenced changes? | sakurasanta86 | Excel | 1 | 08-27-2018 03:23 AM |
 Filling a formula down a column where only one cell value referenced changes?
|
takamaz | Excel | 2 | 03-11-2018 08:56 AM |
| Random cell return using vlookup formula | mattbeaves | Excel Programming | 3 | 05-22-2017 04:38 AM |
|
Formula to return next non-blank cell in a range
|
Anyroad | Excel | 4 | 09-15-2015 04:13 PM |
Windows 10 
Office 2019
Threaded Mode