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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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