madgrrl100
New Member
- Joined
- Jan 27, 2005
- Messages
- 1
I've created a spreadsheet that will act as a price matrix so that me and my colleagues can compile a product price using a variety of options.
The spreadsheet has 11 sections with about half a dozen options in each section. For example section 6 contains 4 case options, of basic £30, mid range £50, high detail £75 and ultra edition £95.
In the cells below, next to cases, I want to be able to input 1, 2, 3, or 4 and for the cell next to it return the relevant price, ie £30, £50 etc. I can then use a formula to reckon up all of the options to give a total product price.
ie
c5= case, c6= option, c7= option cost
The spreadsheet has 11 sections with about half a dozen options in each section. For example section 6 contains 4 case options, of basic £30, mid range £50, high detail £75 and ultra edition £95.
In the cells below, next to cases, I want to be able to input 1, 2, 3, or 4 and for the cell next to it return the relevant price, ie £30, £50 etc. I can then use a formula to reckon up all of the options to give a total product price.
ie
c5= case, c6= option, c7= option cost