Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    May 2003
    Location
    Nottinghamshire, England
    Posts
    211
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rounding off to the nearest Tenth (Excel 2002)

    Hello everyone:

    Can anyone advise me on how I can round a column of to the nearest tenth.

    P r i c e G s t P s t T o t a l
    $359.40 $25.16 $28.75 $53.91

    I have posted a sample, I am trying to take receipts, and enter them into an expense sheet for myself, however, I am sometimes off by a penny.

    Thanks

    dillon

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Rounding off to the nearest Tenth (Excel 2002)

    Do you want to round off the display only, or the underlying value?

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Rounding off to the nearest Tenth (Excel 2002)

    Hi Dillon,

    Your discrepancy is likely caused by the use of a formula to calculate some of the values. Here's a couple of ways to fix the problem, depending on what you're trying to do:
    . if you use Tools|OptionsCalculation and check the 'Precision as displayed' option, Excel will ignore the hidden portion of any displayed value. For example, insert =1/3 in cell A1 and copy down three rows. Next put the formula =SUM(A1:A3) in cell A4. Normally, this will give the result as '1'. Now, format the 1/3 results to show as '0.333', then check the 'Precision as displayed' option. You'll get a warning but, once you understand the effect, as I'll explain, you can ignore it. Now you'll see the result displayed as '0.999'. Reformat one '0.333' to '0.33' and you'll get '0.996'. If you uncheck the 'Precision as displayed' option, you'll get the original result back.
    . wrap a 'ROUND' function around your formulae. For example, say you've got a formula like =A2*.07 to calculate the GST. Use =ROUND(A2*.07,2) instead to get a result that is explicity rounded to two decimal places. Likewise if you've got =A2*.08 to calculate the PST (ie Use =ROUND(A2*.08,2)). You can also round up and down. See Excel's help file for more info.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    3 Star Lounger
    Join Date
    May 2003
    Location
    Nottinghamshire, England
    Posts
    211
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding off to the nearest Tenth (Excel 2002)

    Hello Hans, macropod:

    Hans all I wanted to do was get the final amount which I see on the receipts, after taxes.

    Macropod, I do believe that you have missed your calling, if you are not a teacher, you should be. Your explanation is absolutely brilliant.

    Thank you so very very much.

    dillon

Posting Permissions

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