+ Reply to Thread
Results 1 to 8 of 8

Round off values in Excel

  1. #1
    Registered User
    Join Date
    04-06-2006
    Posts
    12

    Round off values in Excel

    Hi,
    I have some values with decimal points...eg 2.4356
    I want to round them to the nearest value with one decimal place (say 2.4 in this case) for some calculation purpose.
    How can i achieve in Excel 2003?

    Appreciate your help

    Regards,
    Harsha

  2. #2
    Registered User
    Join Date
    02-01-2006
    Posts
    60
    You can use ither ROUND() ROUNDUP() or ROUNDDOWN() functions. You just need to enter the Cell number and no of DP you would like.

    i.e =round(A1,1) for 1dp.

    Thanks
    Gazzr

  3. #3
    Bob Phillips
    Guest

    Re: Round off values in Excel


    See

    http://www.xldynamic.com/source/xld.Rounding.html
    Rounding In Excel

    --
    HTH

    Bob Phillips

    (remove xxx from email address if mailing direct)

    "harshaputhraya"
    <harshaputhraya.27biha_1146804601.3144@excelforum-nospam.com> wrote in
    message news:harshaputhraya.27biha_1146804601.3144@excelforum-nospam.com...
    >
    > Hi,
    > I have some values with decimal points...eg 2.4356
    > I want to round them to the nearest value with one decimal place (say
    > 2.4 in this case) for some calculation purpose.
    > How can i achieve in Excel 2003?
    >
    > Appreciate your help
    >
    > Regards,
    > Harsha
    >
    >
    > --
    > harshaputhraya
    > ------------------------------------------------------------------------
    > harshaputhraya's Profile:

    http://www.excelforum.com/member.php...o&userid=33225
    > View this thread: http://www.excelforum.com/showthread...hreadid=539161
    >




  4. #4
    Registered User
    Join Date
    05-14-2006
    Posts
    5

    Rounding up

    Rounding up to the nearest 1/8

    Along the same lines as the initial question I need for 3 columns on my spreadsheet to round up to the nearest .125 of a percent

    This is for mortgage financing purposes and I haven't been able to acheive this. Any help would greatly be appreciated...

    Thanks
    Cary D

  5. #5
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    To round a percentage in A1 up to the next 1/8 of a percent

    =CEILING(A1,1/800)

    or if you're deriving the value in A1 from a formula just replace A1 with your formula in the above

  6. #6
    Registered User
    Join Date
    05-14-2006
    Posts
    5

    Not sure what you mean

    I am diriving the value of the cell from a formula and I'm not sure what to replace. Can you explain what I need to do?

  7. #7
    Bob Phillips
    Guest

    Re: Round off values in Excel

    He means to replace the A1 in =CEILING(A1,1/800) with whatever formula is in
    A1.

    --

    HTH

    Bob Phillips

    (remove nothere from the email address if mailing direct)

    "caryd" <caryd.27tkpm_1147647301.3433@excelforum-nospam.com> wrote in
    message news:caryd.27tkpm_1147647301.3433@excelforum-nospam.com...
    >
    > I am diriving the value of the cell from a formula and I'm not sure what
    > to replace. Can you explain what I need to do?
    >
    >
    > --
    > caryd
    > ------------------------------------------------------------------------
    > caryd's Profile:

    http://www.excelforum.com/member.php...o&userid=34433
    > View this thread: http://www.excelforum.com/showthread...hreadid=539161
    >




  8. #8
    Registered User
    Join Date
    05-14-2006
    Posts
    5

    I got it now

    I fugured out what you meant by replacing A1 with the formula. Now it reads: =CEILING(T2+U2,1/800)

    Thank you for your assistance.

+ 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