IF FUNCTION

L

Lando

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

Arvi Laanemets

Hi


Lando said:
Why excel only allow us to create max 7 if fuction in one formula.
How to manage if we want more ..
Click to expand...

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

Michael M

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
 
Top