Adding percentage to cell amount using a checkbox

[luke050585]

Hi All

First time poster, and very new to excel, so please be kind.

This may be a simple question for most of you, but as I'm relatively new to everything in excel bar basic formulas, I'm struggling. Been googling this for hours and can't find an answer (or don't know how to word in correctly in excel!).

I'm trying to help my work produce a document which can easily help us work a price out for items we sell. Our items are custom made, and the price can be affected by several options.

So say we have a base price for the material used in making the item. Say, the material used costs us £0.55. We can then add several options to the material price to increase the price. I'll call these Option A, Option B, Option C and so on. Option A may add 10% to the price. Option B may add 5%. Option C may add another 10%.

I want to create check boxes for the options, so when checked, the percentage gets added onto the original material cost. I will then have a cell where the total cost is displayed after selecting all applicable options.

Is this even possible? If so, how and what do I need to look into to make this possible? Sorry for the amateurish explanation.

 

[Fluff]

Hi & welcome to MrExcel.
I would tend to go with a lookup table & formulae, rather than checkboxes. Something like

Excel 2013/2016
	A	B	C	D	E
1		Price	A	B	C
2	Wood	£0.55	£0.61	£0.66	£0.72
3	Metal	£1.50	£1.65	£1.80	£1.95
4	Glass	£2.00	£2.20	£2.40	£2.60
5	Plastic	£0.23	£0.25	£0.28	£0.30
Prices

Excel 2013/2016
	A	B	C
1	Material	Option
2	wood	A	£0.61
3	Glass	C	£2.60
Quote

Cell Formulas
Range	Formula
C2	=INDEX(Prices!$C$2:$E$5,MATCH($A2,Prices!$A$2:$A$5,0),MATCH($B2,Prices!$C$1:$E$1,0))

 

[Special-K99]

Check Boxes are linked to a cell you specify in the Format Control, e.g. enter A1
A1 will produce TRUE or FALSE depending on the value of the Check Box

So if you have 3 Check Boxes and you specify the cells A1 B1 and C1, those cells will be TRUE or FALSE

So your formula would be

=0.55+0.55*(A1*10%+B1*5%+C1*10%)

So if all the checkboxes are ticked the formula would be

0.55+0.55*25%

Or you could have the formula as

=0.55*(1+A1*10%+B1&5%+C1*10%)