Posted to microsoft.public.excel.worksheet.functions

Nash13

external usenet poster

Posts: 10

Limit on Logic

I am trying to build a logic statement with 11 arguments. We are using Excel
2003 which I am assuming has a limit on 7 such arguments. I've attached my
formula below, how can I bypass these limits?

Thank you

=IF(D2=10,"250",IF(D2=9,"225",IF(D2=8,"200",IF( D2=7,"175",IF(D2=6,"150",IF(D2=5,"125",IF(D2=4 ,"100",IF(D2=3,"75",IF(D2=2,"50",IF(D2=1,"25",I F(D2=0,"0","N/A"))))))))))

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
I Then logic help	robnet	Excel Worksheet Functions	4	July 13th 07 10:08 PM
If Then logic not enough	workerbeeVAB	Excel Discussion (Misc queries)	4	January 5th 06 05:24 PM
IRR Logic	Carrie	Excel Worksheet Functions	2	November 18th 05 08:59 PM
Nested IF limit or Open parentheses limit	Fred	Excel Discussion (Misc queries)	5	December 23rd 04 03:34 PM
IF THEN LOGIC	flotowntiger	Excel Discussion (Misc queries)	5	December 7th 04 12:12 AM

All times are GMT +1. The time now is 05:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us