+ Reply to Thread
Results 1 to 9 of 9

Mechanics behind Rounddown formula

  1. 11-05-2015, 06:40 PM #1
    Sinep D
    Sinep D is offline
    Guest
    Join Date
    05-09-2015
    Location
    Moon
    MS-Off Ver
    MS office 2013
    Posts
    24

    Mechanics behind Rounddown formula

    Hello friends!

    I am currently using the ROUNDDOWN formula to round to the nearest two decimal places.
    However sometimes it doesn't work when the last decimal is zero. Instead it rounds to the nearest decimal place.
    E.g 70.456 will become 70.46 and 79.10 becomes 79.1. THe issue is that I specifically want to use all two decimals to keep it "neatly formated".

    Current fomula:
    Please Login or Register  to view this content.
    What is the underlying mechanics of ROUNDDOWN formula? Is there any better way to solve this?

    Many Thanks!

    Sinep
    Reply With QuoteRegister To Reply
  2. 11-05-2015, 06:45 PM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Mechanics behind Rounddown formula

    Quote Originally Posted by Sinep D View Post
    79.10 becomes 79.1
    What result do you expect? Do you want to retain the 0?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 11-05-2015, 06:54 PM #3
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Mechanics behind Rounddown formula

    See if this does what you want:

    =TEXT(ROUNDDOWN(C1*100;2);"0.00")&";"&TEXT(ROUNDDOWN(C2*100;2);"0.00")
    Reply With QuoteRegister To Reply
  4. 11-05-2015, 07:00 PM #4
    Sinep D
    Sinep D is offline
    Guest
    Join Date
    05-09-2015
    Location
    Moon
    MS-Off Ver
    MS office 2013
    Posts
    24

    Re: Mechanics behind Rounddown formula

    I will try this. Keep you posted.
    Reply With QuoteRegister To Reply
  5. 11-05-2015, 07:37 PM #5
    Sinep D
    Sinep D is offline
    Guest
    Join Date
    05-09-2015
    Location
    Moon
    MS-Off Ver
    MS office 2013
    Posts
    24

    Re: Mechanics behind Rounddown formula

    It works. But it it would be a pain to edit 250+ cells, containing different amount of C1+...+C10. Any other idea?
    Reply With QuoteRegister To Reply
  6. 11-05-2015, 07:41 PM #6
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Mechanics behind Rounddown formula

    Quote Originally Posted by Sinep D View Post
    It works. But it it would be a pain to edit 250+ cells, containing different amount of C1+...+C10.
    Sorry, don't understand what that means.
    Reply With QuoteRegister To Reply
  7. 11-06-2015, 12:40 AM #7
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,645

    Re: Mechanics behind Rounddown formula

    Quote Originally Posted by Sinep D View Post
    It works. But it it would be a pain to edit 250+ cells, containing different amount of C1+...+C10. Any other idea?
    Just copy and paste to next cells.
    Quang PT
    Reply With QuoteRegister To Reply
  8. 11-10-2015, 04:32 PM #8
    Sinep D
    Sinep D is offline
    Guest
    Join Date
    05-09-2015
    Location
    Moon
    MS-Off Ver
    MS office 2013
    Posts
    24

    Re: Mechanics behind Rounddown formula

    Gentlemen,

    Thanks you so much for your suggestions!

    Sinep
    Reply With QuoteRegister To Reply
  9. 11-10-2015, 06:02 PM #9
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Mechanics behind Rounddown formula

    You're welcome. We appreciate the feedback!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Understanding the mechanics of different Excel functions
    By FJMoussally in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-25-2015, 09:56 PM
  2. New To The Forum and Advanced Excel Mechanics
    By viveksnoop in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-11-2015, 04:14 PM
  3. If and rounddown formula
    By Excel-Access in forum Excel General
    Replies: 2
    Last Post: 07-03-2012, 08:00 AM
  4. [SOLVED] ROUNDDOWN function in IF formula.. ?
    By jamieblue in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-02-2012, 09:24 AM
  5. LOOKUP mechanics
    By eolshenske in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-08-2009, 09:51 AM
  6. What formula I should use: =ROUNDDOWN(H45*0.18;2) or =TRUNK(H45*0.18,2) ??
    By TANDEX in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. What formula I should use: =ROUNDDOWN(H45*0.18;2) or =TRUNK(H45*0.18,2) ??
    By TANDEX in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1