Hello to all!
I have a problem with a formula, i try all combinations but i can't figure it out...
https://imgur.com/a/aPiYK
on the above link is a picture with what i try to use in excel
Red = 10
Blue = 11
Green = 12
Yellow = 13
In the dropdown list if i select the red text i want red from the left to have value 11 (10+1)
If i select blue i want blue from the left to have value 12 (11+1)
same for the green and yellow..
I try for the Q1 cell to enter this formula =10+IF(S1=P1,1,0) and is working when i select RED from the S1 cell
but if i add 1 more function like =10+IF(S1=P1,1,0),IF(S1=P2,1,0) and try to select red again is not working...
I tried all combinations with IF(OR( or OR(IF ... don't know the formula...
Thank you!
Bookmarks