+ Reply to Thread
Results 1 to 2 of 2

round down a percentage

  1. #1
    Forum Contributor
    Join Date
    01-29-2008
    Location
    Scotland
    MS-Off Ver
    2003
    Posts
    237

    round down a percentage

    Just a quick question here.

    I have a cell which is formatted to percentage, its set to no deceimal point, so the figure shown will always be a rounded up figure, is it possibale to round down the percentage figure.

    ie if total is 41.7% with one deceimal point then it displays 42% with no decimal point

    i want 41.7% to display as 41% with no decimal place..

    Hope some one can help

    The Holy grail is within in my reach..... lol

  2. #2
    Forum Expert
    Join Date
    09-09-2005
    Location
    England
    MS-Off Ver
    2007
    Posts
    1,500
    =rounddown(a1,2)

    the percentage is 0.417 so to 2dp is 41%

    Regards

    Dav

+ 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