ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   different result with excel and calculator (https://www.excelbanter.com/excel-worksheet-functions/231128-different-result-excel-calculator.html)

mtf

different result with excel and calculator
 
I'm calculating a loan payment and get different result from Excel &
calculator. Using PMT function for 350,000 at 6% - 30 years = $2,098.43

HP 17bII calc says $1,292.07 -- Who's right?

macropod[_2_]

different result with excel and calculator
 
Hi mtf,

Since you've got Excel, it's pretty easy to prove which is correct (hint: the HP result isn't). I suspect you've entered a parameter
incorrectly into the HP calculator.

--
Cheers
macropod
[Microsoft MVP - Word]


"mtf" wrote in message ...
I'm calculating a loan payment and get different result from Excel &
calculator. Using PMT function for 350,000 at 6% - 30 years = $2,098.43

HP 17bII calc says $1,292.07 -- Who's right?




All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com