Results 1 to 3 of 3

Thread: Auto sum Rounding problem

  1. #1

    Auto sum Rounding problem



    Register for a FREE account, and/
    or Log in to avoid these ads!

    My formula is consistently off on my weekly payroll report by a few pennies.
    can anyone help me with this rounding issue. See below / attached for details:
    thank you. BBClick image for larger version. 

Name:	Capture.JPG 
Views:	16 
Size:	51.1 KB 
ID:	2891

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Try perhaps:

    =ROUND(A1*.05,2)


  3. #3
    thank you!! I know that was a basic question.
    I wasnt aware of the ' ,2 ' to determine how many spaces to round. Thanks for clearing up. I'm good to go now.

Posting Permissions

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