Savings & Debt (Prototype) - Savings Account Check - Rounding Issues

Good Morning!

I came across a small bug in the determination of underfunded accounts in the case that the account balance and current allocation net out to zero. The sheet will consider the account underfunded in this case. I was able to remedy the issue by adding ROUND() functions in the following formulas and making a slight edit to the Savings Account Check banner formula.

AZ13 Underfunded Accounts
This ensures that there are no micro rounding errors when calculating the difference between account balance and current allocation.

=countif(arrayformula(ROUND(AT7:AT-AU7:AU,2)),"<0")

K5 Unallocated
Similar to above, this ensures that there are no micro rounding errors when calculating the difference between the selected account balance and current allocation.

=if(OR(isblank($J$2),ISBLANK(K4)),IFERROR(1/0),ROUND($K$3-$K$4,2))

K1 Savings Account Check
The formula has been tweaked to include an unallocated amount of $0 in the “good” savings account check status.

=if(isblank(J2),"Savings Account Check",if(K5>=0,"👍👍👍 Savings Account Check 👍👍👍",if(K5<0,"👎👎👎 Savings Account Check 👎👎👎","")))

1 Like

These are great refinements, @cculber2. I’m sorry it took me so long to implement them. They are in the newly-published version 0.66.

I’m happy to see you are using the Savings & Debt template and I’m grateful for your keen eye toward making these template better.

1 Like