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?