View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cerobeth cerobeth is offline
external usenet poster
 
Posts: 3
Default 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