BUDGETING
Dear Members
I have Excel sheet with following data ,which kind of formula is used for the table ,I want to use formula for auto fill quantity as per budget.plz help in this regard .File attached
Book W:Picture Chart Computer ScienceChart Budget
item price $.300 $300 $200 $200 $200 available
28,832
Quantity ?? 6,766
10,618
16,633
Regards
akjani
| Attachment | Size |
|---|---|
| budget table.xlsx | 9.67 KB |
What is quantity column?
Is it B column? If yes, how is price calculated? Is each item's price multiplied by number of items, and then each row total has to fit to budget? If so, you can use Solver tool. Check it here: http://excelexperts.com/solution-budgeting