Why excel only allow us to create max 7 if fuction in one formula.
How to manage if we want more ..
Thanks guys

Hi


"Lando" wrote in message
...
Why excel only allow us to create max 7 if fuction in one formula.
How to manage if we want more ..

There are a lot of ways - it depends on your data and on your preferences,
which one to use:

a) Use a lookup table and LOOKUP/VLOOKUP/INDEX/CHOOSE/SUMPRODUCT to return a
value from there
b) Use some mathematical expression to generate wanted result
c) Split multi-lefel IF() into several expressions, and add or concantenate
results of those expressions
d) Use CHOOSE function, to return up to 28 different pre-defined results.
etc.



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )

Hi Lando
Post a sample of wat you are trying to do.
There may be other ways than IF functions.
VLOOKUP perhaps.

Regards
Michael M

"Lando" wrote:

Why excel only allow us to create max 7 if fuction in one formula.
How to manage if we want more ..
Thanks guys