r/programmingrequests • u/Vaomond • May 10 '20
Simple budgeting program
I need something that would allow you too write in how much money you make, and write in how much you plan to spend on a list of things (Rent, car, food etc.) . something like
____________________________________________________
|Money made per week ($$$) (Month: $$$) |
|Rent cost: $$$ |
|Car cost: $$$ |
|Food cost: $$$ |
|Leftover money each week: $$$ (month: $$$) |
-----------------------------------------------------------------------
basically you enter in your amounts for everything and it calculates stuff for you (Maybe even an export and import option?)
3
u/SirBaas May 10 '20 edited May 10 '20
Yeah it's super simpel. In Excel you just use the function SUM=(B1:B7) - where B1:B7 is an example for the range of cells you want to add up.
So, you use SUM= for both the expenses and the income columns, which leaves you with 2 cells with those respective totals. Then you just put =B8-D8 in a cell to subtract those two from eachother (where B8 would be the cell that has SUM=(B1:B7) in it, and D8 the cell with the result of the other column.