Hi experts
I have a spreadsheet where users are asked to enter a date in column F. They then enter a number in column H.
If the number in column H is >3 then the cell in column F will say 'Not applicable'. I need to extend this formula so that if the number in column H <4 and the user has not entered a date in column F the cell will say 'Date required'. I will then cf the cell so that it turns red alerting the user.
This is the formula I have already;
=IF(H37>3,"Not applicable","")
Do I need an IFS or AND in there?
Thanks in advance![]()
Bookmarks