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?