Oct 16 2020 02:38 PM
Hello!
I am having an issue with the attached spreadsheet that the formulas in the tax and insurance schedules are not updating correctly unless I click in to the formula in the cell and hit enter. I have already checked and the sheets are all set to Automatic calculations so that is not the issue. The formulas still calculate when I change one of the cells being checked in the if statement (E17, for example) but the formula is now applying to the wrong cell unless I click on it and hit enter. I have attached a test spreadsheet for reference.
What I need the formula to do the in the sections "Tax Schedule" (A54-A69) and "Insurance Schedule" (G54-G69) is if the month is 1 less than the month of the next disbursement (E17, E18, E19, and/or E20) then the month needs to show up 2 times in a row in the date column (ie. if next disbursement is 5/1/2021, then April 2021 should be on the schedule twice). Currently, if the disbursement date in cells E17-E20 are changed, the formula seems to set the duplicating date back 2 months instead of 1 unless I manually update the formula. I have a similar formula in the schedules in the "payment" column (column B) that works correctly even when I change the disbursement date but column A refuses to update. Any help would be appreciated!
Oct 16 2020 02:49 PM
You have circular references in formulas
with them result is always unpredictable. As first formulas shall be cleaned from such references, and only after that check if result correct or not.
Oct 16 2020 04:58 PM