Thread: How to setup a nested if function with 10 levels?
View Single Post
  #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