I have a formula that updates based on other cells, but with any changes to the cell references the formual is removed.
Cells involved:
A1 = 15000.00
B1 = 9.00%
C1 = 60
D1 = abs(pmt(B1/12,C1,A1) (example the value returned is $311.38)
D2 = Optional Payment or the real payment amount if the estimate is wrong from D1 (example is $350.00)
D3 = Other Payments (example is $50.00)
D4 = D2 + D3
E1 = IF(D2>0,D4,D1+D3) basically stating that if a actual/other payment actually exists, then if uses the acual payment, but if the estimate is correct it will add the other payment to the estimate regardless is the other payment exists or has a value, so the variations can be actual/est + other even if 0.00/estimate.
When the formual works if the information is not present, but when making changes to different values for A1:C1, the formula is E1 is completely removed and defaults to just D4, the formula in D4 does not change nor remove itself. I have tried creating a new sheet but it ends up having the same issue, there are no macros that effect E1, only cells that will pull the info for their own calculations which those work with no issues.
Is there a setting i am missing?
Any help would be appreciated. Thanks in advance
Bookmarks