When you go to the supermarket, you can see many prices are ending with .99, such as $3.99. Do you know how to round prices to end with x.99 in Excel? Today, I will introduce several tricks to handle it. Let’s jump 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:
- Use the below formula to round a price to end in the nearest .99 value in Excel.
=ROUND(price,0)-0.01
Syntax Explanations:
- ROUND – The Excel ROUND function will help to round a number to the specified number of digits.
- 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:
Refer to the below example image.
- Here, we will enter the input values in Column B.
- Now we are going to round up the values to end with x.99.
- 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:
From this article, we have described the simple formula used to round up the values to end with x.99 in Excel. If you have any other ideas or question , do share with us here in the comments section below. Thank you so much for visiting our site. Click here to know more about *Geek Excel **and Excel Formulas *!! **
Top comments (0)