+ Reply to Thread
Results 1 to 7 of 7

Round Down to two Decimals

  1. #1
    Forum Contributor
    Join Date
    06-12-2009
    Location
    Banglore
    MS-Off Ver
    Excel 2007
    Posts
    129

    Round Down to two Decimals

    Hi i am looking for some formula to round off a decimal number

    e.g. A1=8.288
    if I use the formula ROUND(A1,2) the result is 8.29.

    But I am looking for a result 8.288. That means it shoukd not round off rather the after decimal we should have only two numbers.

    8.288 should be 8.28
    27.4627 should be 27.46

    Please help
    Santanu
    Last edited by santanuKD; 12-16-2009 at 07:22 AM.
    Shan

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Excel Decimal Point Rounding to two digits

    Have you tried ROUNDDOWN?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    06-12-2009
    Location
    Banglore
    MS-Off Ver
    Excel 2007
    Posts
    129

    Re: Excel Decimal Point Rounding to two digits

    Yes I have tried with ROUND, ROUNDUP & ROUNDDOWN all leading to round the number to 8.29 .

    I want 8.28. Is there some way out ??

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Excel Decimal Point Rounding to two digits

    care to show an example using ROUNDDOWN(8.288,2) that returns 8.29 - I would like to see that myself.

  5. #5
    Forum Contributor
    Join Date
    06-12-2009
    Location
    Banglore
    MS-Off Ver
    Excel 2007
    Posts
    129

    Re: Excel Decimal Point Rounding to two digits

    I am looking for 8.28 not 8.29

  6. #6
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Excel Decimal Point Rounding to two digits

    As I said post a sample which shows ROUNDDOWN not working ... I hazard a guess no one else will be able to replicate it themselves...

  7. #7
    Forum Contributor
    Join Date
    06-12-2009
    Location
    Banglore
    MS-Off Ver
    Excel 2007
    Posts
    129

    Re: Excel Decimal Point Rounding to two digits

    Hey thats true ROUNDDOWN is the correct solution .. I was having problem with the cell formatting ..

    Thanks all for the quick response.

    Thanks,
    Santanu

+ 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