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
__