Quote:
|
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
Code:
=IF(F70<>"",1,IF(TODAY()-A70>90,2,3))
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
Code:
IF(TODAY()-A70>90,2,3)
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