Hi there, i have created a Budget sheet which works on weekly and monthly basis, showing individual week costs and budget, with profit/loss and a monthly one summing all the values up. The problem i have with this is that every time i open the sheet it keeps giving me an error and i have to update to amend the error. Any fixes for that. (sometimes lots of hashes appear######)
Another question is, i want to know if there is a formula or a function that allows me to reduce the week budget if the current cost in the monthly sheet has exceeded the budget....ie utilities budget is £150 a week in a month its £750 (5 weeks as a month not 4). if in one week i have gone over the budget will i be able to reduce the following weeks budget equally. so that it does not exceed the maximum budget for the month.
Thanks in advance, bit of a nooby, know some from secondary lessons, but that wasn't helpful XD.
Bookmarks