Hi, I'm trying to plan my purchases for Black Friday so I'm trying to create an automated spreadsheet to help me buy as many items as I can under a budget, therefore I'm trying to figure out how I can create a formula to highlight my cell's sums that add up closest to my given budget. I have already written the items and their corresponding market price, discounted price, and total savings along with my budget. Any help in pointing me in the right direction is appreciated, thanks.
Edit: Also apologies, I might have accidentally posted in the wrong forum.
example.xlsx
Bookmarks