Need cell to return NULL if there is a formula in referenced cell

		Microsoft Office Forums > Microsoft Excel > Excel
Need cell to return NULL if there is a formula in referenced cell

FAQ

Thread Tools

Display Modes

10-10-2023, 12:30 PM

wsnow

Windows 10 Need cell to return NULL if there is a formula in referenced cell

Office 2019

Novice

Join Date: Sep 2023

Posts: 24

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.

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