Need Help Ending a Nested Formula Please

T

TKGerdie

I would really appreciate it if someone could help me.
=IF(BG4>0,IF(TODAY()>(BG4+7),"PAST DUE","
"),IF(BE4>0,IF(TODAY()>(BE4+16),"PAST DUE",IF(TODAY()>(BE4+13),"CHECK
PERMIT"," "))))

I finally got this nested formula to do everything I want except one thing.
The main if/then statement, before all the nesting begins doesn't have a
false statement, so its coming up "FALSE" in the cell. I would like to have
it leave it blank, but I've tried inserting the " " in a few different places
and it won't work. What am I doing wrong?
 
K

Kevin B

I made the second IF the false statement of the first IF, and made the third
IF, the false statement for the the third IF, leaving the false statement for
the first IF open for the "" value.

=IF(BG4>0,IF(TODAY()>(BG4+7),"PAST DUE",IF(BE4>0,IF(TODAY()>(BE4+16),"PAST
DUE",IF(TODAY()>(BE4+13),"CHECK
PERMIT")))),"")
 
V

vezerid

Use this small modification:
=IF(BG4>0,IF(TODAY()>(BG4+7),"PAST
DUE",""),IF(BE4>0,IF(TODAY()>(BE4+16),"PAST
DUE",IF(TODAY()>(BE4+13),"CHECK PERMIT","")),""))

Note, In addition to supplying the third argument in the correct IF(),
I also changed your If-False to a blank cell instead of a space (i.e.
"" instead of " "). This way you can later check for blank values.

HTH
Kostis Vezerides
 
K

Kevin B

What I meant to say was:

I made the second IF the false statement of the first IF, and made the third
IF, the false statement for the the second IF, leaving the false statement
for
the first IF open for the "" value.
 
K

Kevin Vaughn

This seemed to do the trick based on my testings:

=IF(G4>0,IF(TODAY()>(G4+7),"PAST DUE"," "),IF(E4>0,IF(TODAY()>(E4+16),"PAST
DUE",IF(TODAY()>(E4+13),"CHECK PERMIT"," ")),""))
 
T

TKGerdie

Thank you so much! This worked great! Very easy. I appreciate you both
answering so quickly. This is a great resource.
 
K

Kevin Vaughn

Forgot to mention that I changed BG4 to G4 and BE4 to E4 because I did not
want to artificially make my test spreadsheet larger than needed.
 
Top