1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

The result of a formula must be multiples of x

Discussion in 'Ask an Excel Question' started by Hans Öjes, Nov 7, 2018.

  1. Hans Öjes

    Hans Öjes New Member

    Messages:
    16
    Hi. I am wondering how to force the result of a formula to only show multiples of a certain number. For example. If the multiple =6, and the formulas result is 4.5, it should display 6. If the result is 7.5, it should display 12

    1.2 => 6
    5.5 => 6
    6.5 => 12
    8 => 12
    11.5 => 12
    14 => 18
    18.2 => 24

    Anyone?

    // Hans
  2. bosco_yip

    bosco_yip Excel Ninja

    Messages:
    2,005
    upload_2018-11-8_5-42-16.png

    B1, copied down :

    =6*(INT(A1/6)+1)

    Regards
    Bosco
  3. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,639
    or
    B1: =CEILING(A1,6)
    copy down
    Last edited: Nov 8, 2018
  4. Hans Öjes

    Hans Öjes New Member

    Messages:
    16
    Thanks, works perfect
  5. Hans Öjes

    Hans Öjes New Member

    Messages:
    16
    Thanks. An even simpler solution
  6. Hans Öjes

    Hans Öjes New Member

    Messages:
    16
    The problem is solved. Should I close the thread somewhere?
  7. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,639
    We don't have a closed thread option
    Because,
    1. You may want to extend the question
    2. Somebody else may have a simpler or different solution
    3. Somebody else may light to thank us for the solution as well

    These maynot be the case in this thread, but thats why we don't close them
    Khalid NGO likes this.

Share This Page