Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 10-11-2023, 04:20 PM
p45cal's Avatar
p45cal p45cal is offline Need cell to return NULL if there is a formula in referenced cell Windows 10 Need cell to return NULL if there is a formula in referenced cell Office 2021
Expert
 
Join Date: Apr 2014
Posts: 956
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
 



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
Need cell to return NULL if there is a formula in referenced cell 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
Need cell to return NULL if there is a formula in referenced cell Formula to return next non-blank cell in a range Anyroad Excel 4 09-15-2015 04:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft