Loan Amortization Formula


Good Day All:

I need some help with my Loan Amortization Formula. I am trying to subtract out the Escrow from the Principal that is included in my payment.

Current Formula Yields $1,771.06 which is incorrect. The correct amount is $322.85 if he Escrow is $1,448.21 per month

=IF(Interest7 = "", "", Payment7 - Interest7 + [Additional Payment]7)

I can share the sheet if it will be easier.

Thanks Smartsheet Community

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!