alternative to if statement

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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message news:[email protected]...
|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.