Posted to microsoft.public.excel.misc

RRDMAT

external usenet poster

Posts: 1

Nested IF statements - maxed out!

I currently have the following formula in a cell:
IF(AND(J40=12,J41="YES"),"Multiple",IF(J39="","",I F(AND(B48="NO",J40=6),SUM(B39,B41,B43)*3,IF(B48="Y ES",SUM(B49:B52,B41,B43,B43,B45),IF(AND(B46="YES", D54="YES"),(((+B39+B41+B43)*2)+B45),IF(B46="YES",( ((+B39+B41+B43)*4)+B45),IF(D54="YES",(((+B39+B41+B 43)*2)+B45),(((+B39+B41+B43)*4)+B45+B45))))))))

I want to add another condition: IF(AND(J40=4,B48="YES"),(B50+B51)*2)

Any ideas on how to get past the limitation of 7? Maybe a better, more
condensed, way to write the formula?

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 statements	[email protected]	Excel Worksheet Functions	3	September 21st 06 10:13 PM
Nested if statements - is there a better way?	masterbaker	Excel Worksheet Functions	3	July 25th 06 04:59 PM
Nested If Statements	Jasmine	Excel Worksheet Functions	2	January 26th 06 03:47 PM
what is the max no. of nested Ifs can an If Statements have in EXC	StevenE	Excel Discussion (Misc queries)	1	June 27th 05 03:03 PM
Do I need nested IF statements?	Jaramya	Excel Worksheet Functions	1	November 5th 04 09:10 PM

All times are GMT +1. The time now is 11:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us