LinkBack URL
About LinkBacks
I am multiplyint an Hourly salary of $32.06 X 2080 (hours) to get the Annual Salary.
the correct numbre should be $66,684.80 but Excell insists that it is $66,677.52 formula is =I2*H2
What is causing the miscalculation? How can I fix it?
I am multiplyint an Hourly salary of $32.06 X 2080 (hours) to get the Annual Salary.
the correct numbre should be $66,684.80 but Excell insists that it is $66,677.52 formula is =I2*H2
What is causing the miscalculation? How can I fix it?
Suggest that the hourly rate is actually $32.0565 and is rounding in the display to $32.06. If you've downloaded the data from your system it may be to several decimal places but your rounding to 2 dp won't change the calculation, it will still use the actual number in the cell, not the rounded number displayed
I'm thinking that 32.06 is not the true value of the cell. That's just the DISPLAYED value.
Is the number manually entered? Select the cell and look at the formula bar. What do you see?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Ok... $35.0565 is the actual. hmm Ok yeah it is rounding up in one column but giving me the actual on the formula.
I didn't see that it was rounding. Thank you very much!
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks