Thread: Help with nested If statements
View Single Post
 
Old 07-16-2018, 01:49 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
Does the test for F70 take precedence over the date test? Assuming so, your formula would be:

=IF(F70<>"",1,IF(TODAY()-A70>90,2,3))
Reply With Quote