+ Reply to Thread
Results 1 to 8 of 8

ROUNDDOWN if decimal values are equal to or less than .15?

Hybrid View

  1. #1
    Registered User
    Join Date
    08-20-2016
    Location
    California, USA
    MS-Off Ver
    2011
    Posts
    35

    ROUNDDOWN if decimal values are equal to or less than .15?

    Does anyone know how to ROUNDDOWN if decimal values are equal to or less than .15?

    Basically, I want to apply the ROUNDDOWN function ONLY if my values in the decimals are equal to or less than .15, I want any figures with decimals greater than .15 to ROUNDUP.

    Thank you in advance to anyone that writes in with a solution!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,454

    Re: ROUNDDOWN if decimal values are equal to or less than .15?

    Can I assume you want to round to integers?

    Basically, you want 0.15000001 to become like 0.5 in a standard rounding scheme. So I would simply add 0.349999999 to the value, and use a regular ROUND() function =ROUND(number+0.34999999,0)
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    536

    Re: ROUNDDOWN if decimal values are equal to or less than .15?

    Another version.
    PHP Code: 
    =ROUNDUP(A1-0.15,0
    Best Regards,
    Maras.

  4. #4
    Registered User
    Join Date
    08-20-2016
    Location
    California, USA
    MS-Off Ver
    2011
    Posts
    35

    Re: ROUNDDOWN if decimal values are equal to or less than .15?

    Is this going to work for a spreadsheet filled with dollar amounts? For example, my sheet consists of cells like this:

    12.50
    11.95
    10.05
    9.83
    12.13
    1.25
    1.13

    I need a formula that's going to scroll through these cells and ROUNDUP if the decimal place values are larger than .15, ROUNDDOWN if the decimal place values are equal to or less than .15

    So values such as 1.13, 10.05 and so forth, all of these need to ROUNDDOWN. Values such as 12.50, 11.95 should ROUNDUP.

    I am rounding to .5 from the dollar - so 1.13 would become .95, 10.05 would become 9.95. 12.50 would become 12.95.

    Does this make sense?

    Thank you for the assistance.

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,454

    Re: ROUNDDOWN if decimal values are equal to or less than .15?

    Have you tried them? I see no reason why either solution would not work for you -- unless there is something that we are not understanding.

  6. #6
    Registered User
    Join Date
    08-20-2016
    Location
    California, USA
    MS-Off Ver
    2011
    Posts
    35

    Re: ROUNDDOWN if decimal values are equal to or less than .15?

    No, it didn't work - I tried it on a 4.35 and it converted the value to 5, instead of 4.95 (.5 from the dollar)

    If the value were 4.15 or 4.12 it should ROUNDDOWN to 3.95 (.5 from the dollar).

  7. #7
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,454

    Re: ROUNDDOWN if decimal values are equal to or less than .15?

    I did not understand that you wanted to go up/down to n.95. I would probably use either formula, then subtract 0.05 from that.

    =ROUND(number+0.34999999,0)-0.05
    =ROUNDUP(number-0.15,0)-0.05

  8. #8
    Registered User
    Join Date
    08-20-2016
    Location
    California, USA
    MS-Off Ver
    2011
    Posts
    35

    Re: ROUNDDOWN if decimal values are equal to or less than .15?

    Your recommendation worked perfectly - it rounds up or down based on the decimal values being lower or higher than .15!

    Thank you very much for the help! Much appreciated!

+ 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. Replies: 2
    Last Post: 05-17-2016, 11:17 AM
  2. Decimal Precision Issue not equal 100
    By cartica in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-02-2015, 08:36 PM
  3. Percentage Values displays as Decimal Values - Excel 2010
    By Adecypher in forum Excel General
    Replies: 3
    Last Post: 05-28-2015, 06:07 PM
  4. [SOLVED] COUNTIFS function w/greater than or equal to, and less than or equal to time values
    By AliciaRenee in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2014, 03:57 PM
  5. Replies: 16
    Last Post: 11-20-2012, 11:32 AM
  6. Replies: 1
    Last Post: 02-09-2010, 05:40 AM
  7. Format display decimal values but no decimal point
    By BecParko in forum Excel General
    Replies: 1
    Last Post: 10-18-2007, 04:42 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1