If statement

[Sheepkin_Coat]

i am doing a spreadsheet for work, i have a drop down list, with 3 items in it, when the user picks item 1 i won't in a different cell a price, so in cell A i put UCA then in cell B it will come up with £295, and if i choose UCA 1 cell B becomes £195 and UCA 2 Cell B will be £95..

How can i do this

[martindwilson]

=if(a1="uca",295,if(a1="uca 1",195,if(a1="uca 2",95,0)))

[arthurbr]

Thread closed - No response to mod request