Shopping list help - add checkmarks with formula's? how to find % off total

wickedgoodsavings

New Member
Joined
Mar 10, 2015
Messages
1
I have been getting pretty into extreme couponing lately, and Ive been working on a spreadsheet that is becoming quite helpful when planning my shopping trips. Here is what I'm working with at this point. This is all working properly when numbers are entered into it by the way.

Capture3_10_2015_6_15_24_PM.jpg


So here is what I want to do:

Insert new columns with checkmarks for double coupons and buy 1 get one free. Right now the 2 rows at the bottom have a formula of D/2 to show the correct amont for B1G1F. but rather than having to add new rows containing the formula, I'd like to have a checkbox in every row that would change the total in column D when checked. It's the same idea for the double coupons. if checked, the total in column F would double. Is this even possible to do?

I also want to figure out how to add a row at the very bottom where you enter a % off, and It will show how much the discount is and a new total.
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

sheetspread

Well-known Member
Joined
Sep 19, 2005
Messages
5,138
Use an if statement to print the total if no Xs are marked in another cell (if you really want checkboxes that can be done also) otherwise the total * 2. You can also multiply the total by whatever percent, example *(1-.2) for 20% off.
 

Forum statistics

Threads
1,171,138
Messages
5,873,996
Members
433,016
Latest member
LorenzAsurza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top