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"

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))

I think I got this wrong as I need the result as “1” if cell F70 is NOT blank and includes a date or text. The result you gave me shows cell result “1” I’d cell F70 is blank - how do I change this part?

You got something wrong here!

Debaser's formula
1. when cell F70 is not empty, returns always 1 (and ignores any value in A70);
2. when cell F70 is empty, returns the value of expression
i.e. either 2, 3, or some error code. Never 1 is returned.

Check cell F70. e.g. enter into some free cell the formula

I can't somehow edit my post (Edit window opens, but the post is not there).

The formula to check cell F70 will be better
When 0 is returned, the cell is empty, otherwise not.

I am none the wiser.
So column A has a manually entered date. Column D will identify Priority. If date in column A is greater than 90 days old from today’s date then column D should state “2”. If the date in column A is less than 90 days old then column D should state “3”. Column F shows a deadline and what I want to do is, if column F shows a deadline date, then column D must show “1” as this will be high priority. Any help what formula I should use?

The formula I gave you works like this:

If F70 has anything in it, it returns 1.
Otherwise, if A70 is more than 90 days old, it returns 2, but if A70 is more recent, it returns 3.

Thank you it worked. I missed a comma. Thank you