if..

P

pierre

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
 
A

akphidelt

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

Pete_UK

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
 
P

pierre

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 ?







">
 
P

Pete_UK

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
 
Top