Hi Bitter Clinger,

Depending on what you're doing, you may not even need the IF function.

For example, suppose you want to test the value in A1 and, depending on the value there, multiply the value in B1 by the value in
another cell. For that you could use something like:
=((A1=0)*D3+(A1=1)*D4+(A1=2)*D5+(A1=3)*D6)*B1
instead of:
=IF(A1=0,D3,IF(A1=1,D4,IF(A1=2,D5,IF(A1=3,D6,0)))) *B1

--
Cheers
macropod
[MVP - Microsoft Word]


"Bitter Clinger" wrote in message ...
I'm trying to write a formula to check for sales totals and then calculate the correct comission. I need to test for nine
conditions but Excel limits the nesting to seven. How do I get around this limitation?