Forum Discussion
Excel formula result doesn't match calculator result
Hi all, New to the board but I did scour it (and other places) for an answer before posting this. I have a pretty simple Excel formula but the result seems incorrect. I am creating a financial co...
Hi Sergei,
Yes I have a Victor 1310 desktop calculator that is primarily for accounting purposes. It does have a physical switch that allows me to change it, and add the thousandths decimal place. When I tried this yesterday, I got 384.991. When I switched it back to 2 decimal places again, it resumed displaying 385.00 as a result.
I'm thinking maybe it is an accounting standard to always round up from the thousandths but honestly I've never heard of it. In any case, my spreadsheet will go forward with an asterisk now.
Yes I have a Victor 1310 desktop calculator that is primarily for accounting purposes. It does have a physical switch that allows me to change it, and add the thousandths decimal place. When I tried this yesterday, I got 384.991. When I switched it back to 2 decimal places again, it resumed displaying 385.00 as a result.
I'm thinking maybe it is an accounting standard to always round up from the thousandths but honestly I've never heard of it. In any case, my spreadsheet will go forward with an asterisk now.
I changed my mind... used the ROUNDUP function to the second decimal place to get totals that match the invoices. Now my spreadsheet matches them and the calculator. Doesn't make much sense to me but better than being off by a penny (which compounds with multiple lines on the spreadsheet). After 5 lines, was off by $0.05....
ROUNDUP(A1*B1,2)
Will deliver: 340.70 * 1.13 = 385.00
ROUNDUP(A1*B1,2)
Will deliver: 340.70 * 1.13 = 385.00