View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lindsielynette lindsielynette is offline
external usenet poster
 
Posts: 2
Default Create formula to choose price based on previous choice.

I'm working on creating a sales order document for photography. I want to be
able to have a column that automatically picks a price based on the dimension
of the print choosen. (i.e. 4 x 6 = 1.50, 5 x 7 = 2.00) That way clients
only pick the dimensions, but don't have to pick the price too.