View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege Beege is offline
external usenet poster
 
Posts: 30
Default alternative to if statement

Dan,

Look at =CHOOSE()
or =LOOKUP()

Beege

"Dan" wrote in message
...
I need to use more than seven arguments in an if statement. What
alternatives do I have? There is no way I can limit my criteria to less
than
seven variables. Please advise.