Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
??
i would like to combine the followings in ONE single formula :
=CHOOSE(MATCH(E44,"X",0),5) =CHOOSE(MATCH(E45,{"X","Y"},0),6,7) =CHOOSE(MATCH(E46,{"z"},0),8) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
??
Assuming that you want the precidence to be in that order and X, Y or Z is
the only thing in the cell then something like: =IF(E44="X",5,IF(E45="X",6,IF(E45="Y",7,IF(E46="Z" ,8)))) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pierre" wrote in message ... i would like to combine the followings in ONE single formula : =CHOOSE(MATCH(E44,"X",0),5) =CHOOSE(MATCH(E45,{"X","Y"},0),6,7) =CHOOSE(MATCH(E46,{"z"},0),8) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
??
THANKS BUT I WOULD LIKE TO KEEP USING (CHOOSE) BECAUSE I WOULD LIKE TO AVOID
USING THE IF FUNCTION (ITS TOO LIMITED)...UNLESS IF THERE IS ANOTHER WAY. =CHOOSE(MATCH(E44,"X",0),5) =CHOOSE(MATCH(E45,{"X","Y"},0),6,7) =CHOOSE(MATCH(E46,{"z"},0),8) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
??
I don't know what you mean by:
USING THE IF FUNCTION (ITS TOO LIMITED)... It seems to me that in this circumstance CHOOSE() is the more limited but if you must use CHOOSE() then something like: =CHOOSE(MAX((E46="Z")*1,(E45="Y")*2,(E45="X")*3,(E 44="X")*4)+1,"",8,7,6,5)) will return the number you want in the precedence that you gave. Please don't use all upper case - there is no need to shout at me. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pierre" wrote in message ... THANKS BUT I WOULD LIKE TO KEEP USING (CHOOSE) BECAUSE I WOULD LIKE TO AVOID USING THE IF FUNCTION (ITS TOO LIMITED)...UNLESS IF THERE IS ANOTHER WAY. =CHOOSE(MATCH(E44,"X",0),5) =CHOOSE(MATCH(E45,{"X","Y"},0),6,7) =CHOOSE(MATCH(E46,{"z"},0),8) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|