+ Reply to Thread
Results 1 to 4 of 4

Rounding a range of numbers to a specific number using an IF statement

  1. #1
    Registered User
    Join Date
    06-29-2012
    Location
    Arizona
    MS-Off Ver
    Excel 2010
    Posts
    1

    Rounding a range of numbers to a specific number using an IF statement

    Hey there,

    Allow me to explain my situation a little further.

    I have a range of decimals that need to be rounded up to a specific decimal.

    Ex: If the # in E8 is greater than or equal to, say .7, round that # up to .13.
    If the # in E8 is greater than or equal to, say .14, round that # up to .19.

    The list goes on...

    I hope this is enough to work with, it's been a looooong day.

    Thanks in advanced!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Rounding a range of numbers to a specific number using an IF statement

    what is the basis of the increase (ie increase to .13), and what is the crieria to decide what gets increased (ie if its .7)?

    perhaps if you upload a sample worksheet showing an example of wha you have, what you want, and how you arrived at that?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Rounding a range of numbers to a specific number using an IF statement

    Getting to .13 from .7 is not rounding UP.

  4. #4
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Rounding a range of numbers to a specific number using an IF statement

    Your description of your problem is far from clear...

    Could you work with something on the lines of this workbook?
    Attached Files Attached Files
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

+ 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