using more than 1 formula in the same cell in excel
I am trying to create an order form where column A has a drop down box to
choose an item and column B has a drop down box to choose a category.
Depending on the choices selected I need to create variable prices.
ie if A = jumper, B = wool then C = £3, but if A = shirt, B = silk then C = £5
Can anyone help me please
|