Posted to microsoft.public.excel.worksheet.functions

Haritt

Posts: n/a

How to setup a nested if function with 10 levels?

I have a nested if functions with 10 levels. Excel says the max is 7 levels.
How can I get the 10 levels in?
=IF($J7="P7",D7*0.00004,IF($J7="P5",D7*0.00004,IF( $J7="P6",D7*0.0004,IF($J7="P5",D7*0.00004,IF($J7=" P4",D7*0.00006,IF($J7="P3",D7*0.00007,IF($J7="P2", D7*0.00006,IF($J7="P1",D7*0.00006,IF($J7="Q1",D7*0 .00009,IF($J7="Q2",D7*.00019,IF($J7="Q3",D7*0.0001 9)))))))))))

Thanks,

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
"IF" function - 7 nested limit	Ed	Excel Worksheet Functions	7	November 3rd 05 08:57 PM
Nested "If" Function	Ms. P.	Excel Worksheet Functions	8	August 19th 05 07:31 PM
Round a number in nested function	kim	Excel Worksheet Functions	1	July 6th 05 11:45 AM
Countif Function -Nested	Angi	Excel Discussion (Misc queries)	7	May 4th 05 07:04 PM
Combining SUM Function with Nested If Statement	Somecallmejosh	Excel Discussion (Misc queries)	3	December 6th 04 04:25 PM

All times are GMT +1. The time now is 06:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us