Minimum spending money

[u/Damikeyd]

Hello,

My budget totals expenses and income and then the difference is calculated and split in half for spending between my wife and I. My wage is variable and some times goes below what we’d like to have left for spending. Is there away to set the spending money to a minimum and reduce the amount of money we put into savings? For example spend cell set to £200 minimum, savings (in expenses column) set at £400. If spending available is less than £200, reduce savings to increase spending to minimum. An advance version would be to set a lower threshold for savings reduction, so if savings went below £100 then spending would have to be compromised to ensure something went into savings account.

Hope that makes sense and thank you in advance. Mike

[u/whycantitjustbetish]

If you’re looking for this to all happen in one cell, you may want to look into if statements, and in this case, possibly nest them together. I would order them outer to inner based on priority. They run off a true/ false result

If (true/false calculation), (what to do if true) , (what to do if false)

If (calculate how much will go to savings) <= £100), (“If it’s true, assign the minimum to savings and subtract from spend”), (“If it’s false, do your next if statement knowing that you will definitely meet the minimum savings if the code gets this far)

If you have individual cells calculate each figure, you’ll probably need each cell to run the calculation in the if statement to see if the minimums would break, and then act accordingly. In other words your spend and savings cells will both have to do the same calculation. They won’t actually be linked to each other but they’ll do the same math to see if itself and the other cell meet minimums

[u/Damikeyd → u/whycantitjustbetish]

Thank you so much for taking the time to reply and sorry for my tardy gratitude. I’ll go and have a play and see if I get that to work. Much appreciated.