+ Reply to Thread
Results 1 to 6 of 6

Calculating Decimals

  1. #1
    Registered User
    Join Date
    09-20-2010
    Location
    Guam
    MS-Off Ver
    Excel 2003
    Posts
    3

    Smile Calculating Decimals

    I am trying to calculate decimals with a maximum of .60 insead of .99 and am having some trouble doing it.

    here is an example of what I am looking for:

    1.30
    2.30

    total: 4.00

    If someone can please help me I would greatly appreciate it! Thank you!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,951

    Re: Calculating Decimals

    Try this
    =ROUND(SUM(A1:A2),0)
    Assuming the values are in A1 and A2

  3. #3
    Registered User
    Join Date
    09-20-2010
    Location
    Guam
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Calculating Decimals

    It sort of works...

    I have a total of 52 decimal numbers I need to add up and when I use that formula it only rounds the total up one.

    For example, my total is 24306.90 when it should be 24311.30. Your formula is giving me 24307.00

    The difference is because it is calculating the ".##" up to .99. I want it to calculate up to .60

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,951

    Re: Calculating Decimals

    Okay, well your example has 1.3 +2.3 and you wanted the answer to be 4.

  5. #5
    Registered User
    Join Date
    09-20-2010
    Location
    Guam
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Calculating Decimals

    Right.

    You may have misunderstood me, I appologize. Here is another example:

    1.45
    2.20
    3.15

    Excel is calculating the above to be 6.80 and I want to to calculate as 7.20. Instead if the decimal going up to .99, I want it to only go up to .60...

    I hope that clarify's things a little better...

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,094

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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