It looks as if VLOOKUP may work but I have other questions now. In using an
array, do I have to use constants, or can I use formulas? I need to take
the sales figure and find the range it is in and then multiply it by a set
percentage to come up with the comission. As the sales figure goes higher,
so does the comission percentage. So how would I use VLOOKUP to find the
range the sales fits into, and then calculate the correct comission and
place it in the proper cell? And can the array reside on another sheet in
the workbook, and if so, how would you reference the other sheet?

Sorry for so many questions.

"Don Guillett" wrote in message
...
Look in the help index for LOOKUP or VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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?