Help with nested If statements

ArviLaanemets · #4 07-16-2018, 03:09 AM

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

Code:

=F70

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional checkbox mailmerge: coding "or" statements within IF statements	mtracy16	Mail Merge	3	05-22-2018 02:03 PM
Nested If Statements in Formula Field to Produce the Diffrnc in Years Between Today's & Entered Date	mshu31	Word	1	02-09-2017 02:04 PM
Error in If statements	Warren99	Excel	8	05-29-2016 01:59 PM
Help with if then statements	brent chadwick	Word VBA	35	07-25-2015 02:41 PM
Using IF statements	stuwoolf	Excel	2	01-10-2015 01:58 PM