+ Reply to Thread
Results 1 to 4 of 4

Get formula to rounddown

  1. #1
    Registered User
    Join Date
    09-23-2007
    Posts
    38

    Get formula to rounddown

    I am using this formula =I13*(1.02264)*(G13)/(3.6) which gives the result 2333.89
    How do I include `rounddown` so that the result reads 2333

    Or is there some other method of doing this.

    Thank you

  2. #2
    Registered User
    Join Date
    01-27-2020
    Location
    United States
    MS-Off Ver
    16
    Posts
    9

    Re: Get formula to rounddown

    I'm not sure if this is the smartest way, but in the next column you can use =FLOOR(A1,1) and just hide the other column?

  3. #3
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Get formula to rounddown

    3 ways.

    =INT(I13*(1.02264)*(G13)/(3.6))

    =TRUNC(I13*(1.02264)*(G13)/(3.6))

    =ROUNDDOWN(I13*(1.02264)*(G13)/(3.6),0)

    I believe Excel has had ROUNDDOWN since Excel 2010. You don't show your Excel version. However, the 1st 2 formulas work at least back to Excel 2000. INT and TRUNC work differently for negative values: INT(-1.8) -> -2, TRUNC(-1.8) -> -1. That is, INT always returns the next smaller integer, TRUNC returns the integer with smaller absolute value.

  4. #4
    Registered User
    Join Date
    09-23-2007
    Posts
    38

    Re: Get formula to rounddown

    hringrv,
    Thank you, when attempting to use COUNTDOWN I was missing the ,0)
    at the end of the formula.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] ROUNDDOWN & ROUNDUP in same formula?
    By Grasshopper Green in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-06-2013, 08:32 AM
  2. Formula error in rounddown
    By Excel-Access in forum Excel General
    Replies: 3
    Last Post: 07-16-2012, 04:16 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. Replies: 8
    Last Post: 09-06-2005, 03:05 PM
  6. [SOLVED] 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, 12:05 PM
  7. [SOLVED] 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, 02:05 AM
  8. [SOLVED] 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

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