+ Reply to Thread
Results 1 to 3 of 3

limiting decimal places - payroll tax

  1. #1
    Registered User
    Join Date
    08-17-2011
    Location
    at home
    MS-Off Ver
    Excel 2003
    Posts
    2

    Smile limiting decimal places - payroll tax

    I am using the sum function to total a row of values in Excel 2003. These values are the results of multiplication functions involving decimals. I have these results formatted as currency (it's a payroll tax calc sheet). My problem is that although Excel displays the result of the multiplication equation with 2 decimal places, I'm thinking it must store the results with more decimal places. Occasionally, my final total is off by a few "pennies". Is there a way to "finalize" the rounding that takes place after the initial multiplication function?


    Here's my specific example: The total of my multiplication functions is $48.87 in currency (but 48.867465 under general formatting). When I double the $48.87, my result shows $97.73 (currency).
    Last edited by jimbo murphy; 08-18-2011 at 09:49 PM.

  2. #2
    Registered User
    Join Date
    08-11-2011
    Location
    Northampton, England
    MS-Off Ver
    Excel 2003
    Posts
    15

    Smile Re: limiting decimal places - payroll tax

    Use the formula =round((multiplication function in here),2) this will then make excel round to the 2dp and the toatal will always be correct.

  3. #3
    Registered User
    Join Date
    08-17-2011
    Location
    at home
    MS-Off Ver
    Excel 2003
    Posts
    2

    Talking Re: limiting decimal places - payroll tax

    Quote Originally Posted by ReeceT View Post
    Use the formula =round((multiplication function in here),2) this will then make excel round to the 2dp and the toatal will always be correct.
    Thanks did it! Thanks!!
    Last edited by jimbo murphy; 08-18-2011 at 09:50 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1