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,
|