we all know that IF function is limited to 7 conditions.
what should i do if i have 15 conditions ? and how to insert them in one
single formula ?

THANKS FOR YOUR HELP

What are you doing that would require 15 conditions? And most likely you
would be better off creating a table and using vlookup or match.

"pierre" wrote:

we all know that IF function is limited to 7 conditions.
what should i do if i have 15 conditions ? and how to insert them in one
single formula ?

THANKS FOR YOUR HELP

Give us more details of what you want to do. There are ways of
combining IFs to overcome the 7-nested limits, but there are also
other ways of coping with multiple choices which don't involve IF.

Pete

On May 6, 10:00*pm, pierre wrote:
we all know that *IF function *is limited to 7 conditions.
what should i do if i have 15 conditions ? and how to insert them in one
single formula ?

THANKS FOR YOUR HELP

here are some details :

erik : is a man , tall , employee ,married , has children , has a car ,do
overtimes
, hard worker, participative , come on time , is under 30 years of age , has
insurance , gets bonus .

i want to do the following :

if erik is a man ...then gets 100 $ orelse 150$
if erik is a tall ...then gets 50$
if erik is hard worker ...then gets 300$
if erik is a man AND is tall...then "accepted"
if erik has children ...then gets 100$
if erik is an employee ...then "employee"
if erik has a car ...then gets 250$
if erik do overtimes ...then gets 500$
if erik is married ...then gets 320$
if erik is a hard worker AND do overtimes ...then gets 700$
if erik is participative ...then gets 230$
if erik is under 30 years of age ...then "acceptable"
if erik comes on time....then "accurate"
if erik has insurance....then "coverd"

HOW TO DO THAT ?







"
On May 6, 10:00 pm, pierre wrote:
we all know that IF function is limited to 7 conditions.
what should i do if i have 15 conditions ? and how to insert them in one
single formula ?

THANKS FOR YOUR HELP

This doesn't make much sense to me. Please explain further, relating
what cells you are using and what you want to see happen.

Pete

On May 7, 6:56*am, pierre wrote:
here are some details :

erik : is a man , tall , employee ,married , has children , has a car ,do
overtimes
, hard worker, participative , come on time , is under 30 years of age , has
insurance , gets bonus .

i want to do the following :

if erik is a man ...then gets 100 $ *orelse 150$
if erik is a tall ...then gets 50$
if erik is hard worker ...then gets 300$
if erik is a man AND is tall...then "accepted"
if erik has children ...then gets 100$
if erik is an employee ...then "employee"
if erik has a car ...then gets 250$
if erik do overtimes ...then gets 500$
if erik is married ...then gets 320$
if erik is a hard worker AND do overtimes ...then gets 700$
if erik is participative ...then gets 230$
if erik is under 30 years of age ...then "acceptable"
if erik comes on time....then "accurate"
if erik has insurance....then "coverd"

HOW TO DO THAT ?

"



On May 6, 10:00 pm, pierre wrote:
we all know that *IF function *is limited to 7 conditions.
what should i do if i have 15 conditions ? and how to insert them in one
single formula ?

THANKS FOR YOUR HELP- Hide quoted text -

- Show quoted text -