Annual rate is not calculating correctly?
Hello,
I am having a formatting (?) issue with a formula I wrote where I'm trying to get the annual rate. First off, I'm multiplying an hourly rate (in column "Hourly Rate") by a percentage of 3.3%. This is what the formula looks like in my Smartsheet workbook:
=[Hourly Rate]@row * 1.033
So for example, $42.52 is entered into an Hourly Rate cell and the result is 43.92316 and when I format that to currency value, it comes out to $43.92 which is entered into a cell under "New Hourly Rate" column. However when I multiply this rate by annual working hours (2080), it doesn't calculate properly? This is what the formula looks like:
=[New Hourly Rate]@row * 2080
So the result (when formatted to currency) is $91,360.17 but when I calculate myself, I got $91,353.60 which is a difference of $6.57. I'm assuming this has to do with the extra decimals, unsure how to correct and have $91,353.60 display? Any feedback will be appreciated.
Thank you!
Answers
-
Use
round function
to keep it consistent to 2 decimal place.=ROUND([Hourly Rate]@row * 1.033,2)
=ROUND([New Hourly Rate]@row * 2080,2)
...
-
Thanks @heyjay that worked! :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!