Posted to microsoft.public.excel.misc

TKGerdie

Posts: n/a

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nested Formula help	Pat Flynn	Excel Worksheet Functions	0	December 5th 05 04:25 PM
Nested Formula	MichaelS	Excel Worksheet Functions	6	November 28th 05 07:54 PM
Excel nested IF formula question	[email protected]	Excel Discussion (Misc queries)	6	November 10th 05 05:11 PM
UPDATED - Referencing named Ranges within a Nested IF formula	JTinAtlanta	Excel Worksheet Functions	1	July 29th 05 11:46 PM
IF / SUM - Nested Formula Required?	Annabelle	Excel Discussion (Misc queries)	4	May 10th 05 10:49 PM

All times are GMT +1. The time now is 08:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us