Microsoft Office Forums - View Single Post - Help with nested If statements

Thread: Help with nested If statements

View Single Post

Old

07-16-2018, 01:45 AM

Aliwoods

Aliwoods is offline

Aliwoods uses Windows XP

Windows XP Aliwoods uses Office 2016

Aliwoods uses Office 2016

Office 2016

Novice

The original poster

Join Date: Jul 2018

Posts: 4

Aliwoods is on a distinguished road

Default

Help with nested If statements

Can someone please tell me what is wrong with this nested If statement?

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

What I am trying to do is show a result of either "2" or "3" depending if date in cell A70 is less than/greater than 90 days from todays date
And
if cell F70 is not left blank to show a result of "1"

Reply With Quote