How can I create a clickable list that will apply one of various formulas to a column?
Solution 1:
use CHOOSE() . From ur :
create dropdown autocompletion
use it to 'drive' its selection. Eg :
A1 : put a value
B1 : type A , B or C
C1 : =CHOOSE(MATCH(B1,{"A","B","C"},0),A1*1,A1*2,A1*3)
Please share if it works/not/understandable.