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
-
No need to Reply. I figured it out.
Answers
-
No need to Reply. I figured it out.
-
Glad to hear you got it working!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!