Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 06-29-2017, 11:26 PM
joeu2004 joeu2004 is offline WHy the difference in amounts Windows 7 32bit WHy the difference in amounts Office 2007
Advanced Beginner
 
Join Date: Aug 2016
Posts: 32
joeu2004 is on a distinguished road
Default

Quote:
Originally Posted by joeu2004 View Post
But more to the point: I believe that both formulas are incorrect, if your intent is to incorporate 1.5x overtime pay into gross wages in I2.
The problem was resolved in email.

The primary problem was knowing how to calculate overtime for Ohio. It is much simpler than Calif: just 1.5 time for hours worked over 40. So the formula in I2 should be:

=ROUND(H2 + MAX(0,H2-40)*0.5) * 9.25, 2)

There were also some formulas that require explicit rounding. But that issue was secondary and not related to the "difference".

Interestingly, the example Excel file demonstrates why "Precision As Displayed" should not be set in this case.

Work time was calculated for each day of the week and converted to decimal hours. The number of hours needed to be calculated exactly (not rounded), but they are formatted to display only 2 decimal places. Setting PAD would have rounded those values to 2 decimal places.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
IF formula when some values are text & others $ amounts LyndaH Excel 4 03-26-2017 08:31 PM
Adding addresses and $ amounts to Word docs littlepeaks Word VBA 2 01-22-2016 07:57 PM
WHy the difference in amounts Tracking Amounts teza2k06 Excel 1 04-13-2014 09:28 PM
WHy the difference in amounts Vlookup help for large amounts of stock data jyfuller Excel 15 09-21-2012 11:35 AM
WHy the difference in amounts indent alternate lines by different amounts rufusfrog Word VBA 5 02-25-2012 03:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft