Need Help Ending a Nested Formula Please
 

I would really appreciate it if someone could help me.
=IF(BG40,IF(TODAY()(BG4+7),"PAST DUE","
"),IF(BE40,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?

Need Help Ending a Nested Formula Please
 

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(BG40,IF(TODAY()(BG4+7),"PAST DUE",IF(BE40,IF(TODAY()(BE4+16),"PAST
DUE",IF(TODAY()(BE4+13),"CHECK
PERMIT")))),"")
--
Kevin Backmann


"TKGerdie" wrote:

I would really appreciate it if someone could help me.
=IF(BG40,IF(TODAY()(BG4+7),"PAST DUE","
"),IF(BE40,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?

Need Help Ending a Nested Formula Please
 

Use this small modification:
=IF(BG40,IF(TODAY()(BG4+7),"PAST
DUE",""),IF(BE40,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

Need Help Ending a Nested Formula Please
 

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.

--
Kevin Backmann


"Kevin B" wrote:

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(BG40,IF(TODAY()(BG4+7),"PAST DUE",IF(BE40,IF(TODAY()(BE4+16),"PAST
DUE",IF(TODAY()(BE4+13),"CHECK
PERMIT")))),"")
--
Kevin Backmann


"TKGerdie" wrote:

I would really appreciate it if someone could help me.
=IF(BG40,IF(TODAY()(BG4+7),"PAST DUE","
"),IF(BE40,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?

Need Help Ending a Nested Formula Please
 

This seemed to do the trick based on my testings:

=IF(G40,IF(TODAY()(G4+7),"PAST DUE"," "),IF(E40,IF(TODAY()(E4+16),"PAST
DUE",IF(TODAY()(E4+13),"CHECK PERMIT"," ")),""))
--
Kevin Vaughn


"TKGerdie" wrote:

I would really appreciate it if someone could help me.
=IF(BG40,IF(TODAY()(BG4+7),"PAST DUE","
"),IF(BE40,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?

Need Help Ending a Nested Formula Please
 

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

"vezerid" wrote:

Use this small modification:
=IF(BG40,IF(TODAY()(BG4+7),"PAST
DUE",""),IF(BE40,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

Need Help Ending a Nested Formula Please
 

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.
--
Kevin Vaughn


"TKGerdie" wrote:

I would really appreciate it if someone could help me.
=IF(BG40,IF(TODAY()(BG4+7),"PAST DUE","
"),IF(BE40,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?