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 can construct them in VBA,.

"Dan" wrote:

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.

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.

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.

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

http://www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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