So far we have learned the simple formulas to round a number up in Excel. Similarly, here we will guide you to round a number up to the nearest multiple values in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- If you want to round a number up to the nearest multiple values in Excel, use the below formula.
=CEILING(number,multiple)
Syntax Explanations:
- CEILING – In Excel, the CEILING function will help to round a given number to the nearest specified multiple.
- Number – It represents the input values from your worksheet.
- Multiple – It specifies the nearest multiple values.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Example:
Refer to the below example image.
- First, we will enter the input values in Column B.
- Now we are going to round these input values by the nearest multiple values which are given in Column C.
- So, apply the above-given formula to the formula bar section and press the ENTER key.
- Finally, we will get the result in the selected cell as shown in the below image.
Wrap-Up:
From this tutorial, we have explained the simple formulas to round a number up to the nearest multiple values in Excel. Hope you like it. Mention your queries in the below comment box. Thank you so much for visiting our site. Click here to know more about *Geek Excel **and Excel Formulas *!! **
Top comments (0)