Loan Amortization Formula

Tony Barthelemy

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

Tony Barthelemy

No need to Reply. I figured it out.

Tony Barthelemy

No need to Reply. I figured it out.

Genevieve P.

Glad to hear you got it working!