Dynamic Component attribute question
-
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.
-
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 functioncost =choose(optionindex("drop"),$12,$15.....$n)
the number of choices = numder in dropdown
-
Thank you pcmoor. i was able to use =CHOOSE(OPTIONINDEX. It gave me the result i was looking for. Thanks for the help!
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better đź’—
Register Login
Advertisement