hermesalpha
asked on
in Excel 2007, what is wrong with my CHOOSE MATCH formula?
I have this formula in cell CN2616:
=IF(OR(CM2616="";CM2616="I ngen bedömning");1;CHOOSE(MATCH (CM2616;{" Lägsta betydelse";"Låg betydelse";"Medelstor betydelse";"Hög betydelse";"Högsta betydelse"};1);0.6;0.8;1;1 .2;1.4))
Then I have a drop-down list in cell CM2616 with these options:
- ;Ingen bedömning;Lägsta betydelse;Låg betydelse;Medelstor betydelse;Hög betydelse;Högsta betydelse
It works fine when I don't select anything, when I select "Ingen bedömning", and when I select "Medelstor betydelse". In all these three cases the value becomes 1.0 in CN2616.
But when I select any of the other options, I get a "#N/A" error. Why, and what do I need to change in the formula so it works for the other options?
=IF(OR(CM2616="";CM2616="I
Then I have a drop-down list in cell CM2616 with these options:
- ;Ingen bedömning;Lägsta betydelse;Låg betydelse;Medelstor betydelse;Hög betydelse;Högsta betydelse
It works fine when I don't select anything, when I select "Ingen bedömning", and when I select "Medelstor betydelse". In all these three cases the value becomes 1.0 in CN2616.
But when I select any of the other options, I get a "#N/A" error. Why, and what do I need to change in the formula so it works for the other options?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@Mike - Some international versions of Excel use semi-colon as a separator rather than a comma.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your explanation and solution Rob, the formula works as it should now.