IF FUNCTION
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 )
|