Posted to microsoft.public.excel.worksheet.functions

sernst

external usenet poster

Posts: 2

Need to add to nested IF

I'm brain dead and tired of looking at this.

I need to add this primary condition: IF($BH11=0,0,...
to this formula:

=IF(OR($S11="7000",$S11="8000",AND($S11="1000",$R1 1<=0.001),AND($S11="1000",$D$7="Y")),IF(AND($S11=" 1000",$D$7="Y"),$C$7,21),IF($S11="1000",IF($R11<1, 90,IF($R11<5,75,IF($R11<10,50,IF($R11<25,35,IF($R1 1<40,30,IF($R11<80,20,15)))))),0))

Thanks in advance for any help.

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 if	ab3d4u[_25_]	Excel Worksheet Functions	5	December 19th 07 06:46 PM
Nested if help	Curtis	Excel Worksheet Functions	1	December 5th 07 06:03 PM
nested if	Janis	Excel Discussion (Misc queries)	3	July 27th 07 11:54 PM
nested if based on nested if in seperate sheet. how?	scouserabbit	Excel Worksheet Functions	5	March 2nd 07 04:03 PM
More than 16 nested IFs!!!!	Meltad	Excel Worksheet Functions	11	October 6th 06 09:49 AM

All times are GMT +1. The time now is 06:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us