alternative to if statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Depending on what you're actually doing, you may be able to use some sort of
Lookup table. You also may be able to use the OR function. But once again,
it depends on exactly what you're doing with your IF statements.
 
http://www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Equation Efficiency? 1
IF - more than seven arguments 2
nested if statements 1
Nest more then seven if conditions 9
IF statement comparing month and year separately 6
Avoiding Nested 'IF' Statements 9
Large formulas 5
entering more than seven levels of functions with in a function 2

Back
Top