Using More than 7 possibilities in a formula
 

How do I use more than 7 possibilities in a formula. I know basically you
can't nest more than 7 formulas in one.

Any suggestions would be helpful

Using More than 7 possibilities in a formula
 

Check out VLOOKUP in help,
Regards,
"saschmeling" wrote in message
...
How do I use more than 7 possibilities in a formula. I know basically you
can't nest more than 7 formulas in one.

Any suggestions would be helpful

Using More than 7 possibilities in a formula
 

you can also create a named formula in the name manager, insert further
nesting and include that in the original formula

"saschmeling" wrote:

How do I use more than 7 possibilities in a formula. I know basically you
can't nest more than 7 formulas in one.

Any suggestions would be helpful