Thread: [Solved] Need cell to return NULL if there is a formula in referenced cell
View Single Post
 
Old 10-11-2023, 04:20 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
=IF(LEN($T2)<2,"", MAX(0,$T2-TODAY()))


It's <2 in the formula because the formula for most cells in column T is:
=IF(ISBLANK($Q2)," ", DATE(YEAR($R2),MONTH($R2),(DAY($R2)-60)))
where there is a single space between the double quotes. If you had nothing between the double quotes the formula would be a more traditional:
=IF(LEN($T2)<1,"", MAX(0,$T2-TODAY()))


BTW, consider shortening the formula in column T to:
=IF(ISBLANK($Q2),"", $R2-60)
Reply With Quote