JohnnyPicnic
New Member
- Joined
- Feb 8, 2021
- Messages
- 17
- Office Version
- 2019
- Platform
- Windows
Hi all,
I'm attempting to perform and IF statement against a cell that is sometimes blank and sometimes contains a date. The expected result is:
blank = leave blank
greater than 30 days = Data↑
between 15-30 days = Data↓
my formula =IF(TODAY()-D7>30, "Data↑", IF(AND(TODAY()-D7>=15, TODAY()-D7<=30), "Data↓",""))
I can't get to a formula that leaves the cell blank.
I'm attempting to perform and IF statement against a cell that is sometimes blank and sometimes contains a date. The expected result is:
blank = leave blank
greater than 30 days = Data↑
between 15-30 days = Data↓
my formula =IF(TODAY()-D7>30, "Data↑", IF(AND(TODAY()-D7>=15, TODAY()-D7<=30), "Data↓",""))
I can't get to a formula that leaves the cell blank.