Dynamic Component attribute question

[iclifton]

My question is probably a simple one. If i create an attribute to return the cost of an item based on the model number, which i already have set up in a pull down list. When i use the =if formula, i can only go out 3 cost. i have eight model numbers. Is there a different formula that i can use or am i doing something wrong.

[pcmoor]

you can use nested if statements, however it is best to use the choose function, based on the dropdown index. CHOOSE(index,value1,value2,...valueN)

cost =choose(drop,$12,$15.....$n)
drop item 2 (where the value =2)

or if value of drop is some function or not a consecutive integer,
then use OPTIONINDEX("attributeName")
within the choose function

cost =choose(optionindex("drop"),$12,$15.....$n)

the number of choices = numder in dropdown

[iclifton]

Thank you pcmoor. i was able to use =CHOOSE(OPTIONINDEX. It gave me the result i was looking for. Thanks for the help!