IF FUNCTION

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub countm in filter 4
Paste and Link 3
problem of an empty cell 5
Hide rows function 4
HELP!! Unsolved Mystery 2
IF Function 5
= If (in list) 1
How to Format a Nested Function (Bold) 2

Back
Top