Max spending with budget formula options
Hi, could some please have a look at the attachment. I cannot quite figure out how to elegantly solve this issue.
In this sheet a user inputs a list of things he wants to spend money on (including the price). Then the user input the total budget. The output should then be which items money can be spend on without exceeding the budget.
Thanks in advance.
See attached.
I've used one helper column to track running total. Drag it down as far as you like.
This column will calculate automatically.
You don't need other columns.
Formula for display:
Adjust the references as required.HTML Code:
Does that work for you?
1. Click on the * Add Reputation if you think this helped you
2. Mark your thread as SOLVED when question is resolved
Modytrane
Welcome to the forum.
If you just keep the 'Sum Value' column, then you can use this in the 'Output' cell:
Formula:
Please Login or Register to view this content.
You can convert this to a CONCAT function if you want, instead of using the & symbol.
For the 'Sum Value' column, put this in C2:
Formula:Please Login or Register to view this content.
You can then just double-click the bottom right of cell C2 (select it first) and it will fill the formula down as far as you have entries in column B.
Hope that helps.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Thanks so much for all your responses, this really helps me out!
You're welcome, glad we could help. Thanks for the rep and for marking the thread as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks