Forum Discussion
countrymanofit
Mar 17, 2020Copper Contributor
Excel Foruma to calculate down payment
Hi All, It has been a while since I've done anything related to this in excel and Google is not being my best friend right now. I have an excel spreadsheet that Column A that has the loan am...
- Mar 17, 2020
You appear to have entered
= Amount - PercentDown
rather than
= Amount * (1 - PercentDown)
PeterBartholomew1
Mar 17, 2020Silver Contributor
You appear to have entered
= Amount - PercentDown
rather than
= Amount * (1 - PercentDown)
countrymanofit
Mar 17, 2020Copper Contributor
PeterBartholomew1 That worked, Thank you!
I knew it was easy, and apparently my math was wrong to, 20% of 250,000 is 50,000... Shows how much I can think today.