Question:

How can I get a nearest multiple of 10(higher side) of a particular number?

by  |  earlier

0 LIKES UnLike

If a number is 252 in cell A1 then I want 260 in the cell B1

 Tags:

   Report
Answer The Question I've Same Question Too

2 ANSWERS

Sort By: Date  |  Rating

  1. Use the "integer part" function (IP)

    In B1: say

    10 * IP((A1+9)/10)

    Explanation:

    The " +9 " raises the quotient to the nearest HIGHER multiple of 10.

    If the value is 251 this gives you 260.

    If the value is 269 this gives you 260.

    But

    If the value is 260 this also gives you 260.


  2. put the formula =ROUNDUP(A1,-1) in B1
You're reading: How can I get a nearest multiple of 10(higher side) of a particular number?

Question Stats

Latest activity: earlier.
This question has 2 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now