Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > How to setup a nested if function with 10 levels?
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Haritt
 
Posts: n/a
Default 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 QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael M
 
Posts: n/a
Default How to setup a nested if function with 10 levels?
Hi
Have a look in Help for VLOOKUP.
This will give you a simpler method than using nested "IF's"

HTH
Michael
"Haritt" wrote:

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 QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default How to setup a nested if function with 10 levels?
=IF(OR($J7="Q2",$J7="Q3"),D7*0.00019,IF(OR($J7="P7 ",$J7="P5"),D7*0.00004,IF(
$J7="P6",D7*0.0004,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,""))))))))

Vaya con Dios,
Chuck, CABGx3


"Haritt" wrote in message
...
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.0 0009,IF($J7="Q2",D7*.00019
,IF($J7="Q3",D7*0.00019)))))))))))

Thanks,




Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Buttrey
 
Posts: n/a
Default How to setup a nested if function with 10 levels?
On Wed, 8 Mar 2006 14:33:06 -0800, Haritt
wrote:

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.000 19)))))))))))

Thanks,


=IF(OR($J7="P7",$J7="P5",$J7="P6"),D7*0.0004,IF(OR ($J7="P4",$J7="P2",$J7="P1"),D7*0.0006,IF($J7="P3" ,D7*0.0007,IF($J7="Q1",D7*0.00009,D7*0.00019))))

Rgds

Richard Buttrey
__
Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Haritt
 
Posts: n/a
Default How to setup a nested if function with 10 levels?
Thanks, It worked and it let me copy it to other cells. I tried the name
and define function but it does not copy to multiple cells and adjust the
cell numbers.

Haritt

"CLR" wrote:

=IF(OR($J7="Q2",$J7="Q3"),D7*0.00019,IF(OR($J7="P7 ",$J7="P5"),D7*0.00004,IF(
$J7="P6",D7*0.0004,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,""))))))))

Vaya con Dios,
Chuck, CABGx3


"Haritt" wrote in message
...
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.0 0009,IF($J7="Q2",D7*.00019
,IF($J7="Q3",D7*0.00019)))))))))))

Thanks,





Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear 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 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement