Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have created a payroll fee calculation worksheet and am
having a problem with the rounding. EX:20 employees W-2's at $1.50 per and a One time $5.00 Fee. I want to spread the cost to the client out over 2 weeks. 20 X 1.50= $30.00 + $5.00 = $35.00 / 52wks = 0.673076923076923076923076923076923. If I round to .67 the total is only $34.84 not $35.00. How/What do I need to do to calculate the true amount of $35.00. Please keep in mind that other clients will have a different number of employees so the variences will differ. Thank you, Stumped |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Sum and rounding functions | Excel Worksheet Functions |