We have already learned how to round a price to end with X.99 in Excel. Likewise, here we will discuss some formulas to round prices to end in X.45 or X.95 in Excel. Let’s get them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- Use the below formula to a price value to end in .45 and .95 in Excel.
=CEILING(price,0.5)-0.05
Syntax Explanations:
- *CEILING * – In Excel, the CEILING function will help to round a given number to the nearest specified multiple.
- *Price * – It represents the input values from your worksheet.
- 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.
Practical Example:
Let’s consider the below example image.
- First, we will enter the input values in Column B.
- Here we are going to round up the values to end in x.95 or x.45.
- 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.
Conclusion:
So this was a simple guide to round prices to end in X.45 or X.95 in Excel. I tried to be explanatory. I hope it helps you guys. Leave a comment or reply below let me know what you think! Thank you so much for visiting our site. Click here to know more about *Geek Excel **and Excel Formulas *!! **
Top comments (0)