LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Rounding in functions

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH SunshineinFt.Myers[_2_] Excel Worksheet Functions 7 March 5th 09 06:41 PM
How to convert cell formula functions to code functions Adnan Excel Discussion (Misc queries) 1 October 1st 08 08:30 PM
I need a formula with rounding up & rounding down to the nearest . Tony Kay Excel Worksheet Functions 3 May 29th 07 11:13 PM
efficiency: database functions vs. math functions vs. array formula nickname Excel Discussion (Misc queries) 2 July 14th 06 04:26 AM
Sum and rounding functions colleen Excel Worksheet Functions 2 May 18th 06 07:01 PM


All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"