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

wsnow · #3 10-11-2023, 07:34 AM

Sorry, but that didn't work at all. Got a #VALUE! error on the rows that actually have dates in the column T cell, and a FALSE error on the rows that don't have dates (but have formulas).

I've attached the file.

The worksheet will have a variable number of rows that contain data so I need the formula to appear in all the table rows but not return an error message if it has no date. I've done this successfully with other formulas but somehow am missing it with this one.

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