View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default function nesting limitations

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?