•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Calculation in Excel differs from amount using handheld calculator
I know next to nothing about Excel but am trying to learn and make a worksheet to figure out how much of my Social Security is taxable. There is an online calculator and when I compare my result to that, it's a dollar off. I narrowed down the problem to one cell. I need 85% of the amount in B24. So I entered =B24*.85. The amount in B24 is $13750 and Excel works it out to $11687.36 which it rounds down to $11687. The online calculator gives me $11688. And if I do the math on my handheld calculator it gives me $11687.50 - which would be rounded up to $11688. Where is Excel getting $11687.36? I can't figure it out.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#rows.com
#Excel
#calculator
#B24
#calculation
#Social Security
#taxable
#rounding
#online calculator
#amount
#handheld calculator
#worksheet
#percent
#math
#tax
#dollar
#difference
#figuring