Excel Formulas to Round Prices to End in X.45 or X.95 ~ Easy Guide!!
Tags: excelformula, excelformulas
Published: 2021-04-26 12:41:53

---
title: Excel Formulas to Round Prices to End in X.45 or X.95 ~ Easy Guide!!
published: true
date: 2021-04-23 08:05:48 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-round-prices-to-end-in-x-45-or-x-95-easy-guide/
---

We have already learned how to **[round a price to end with X.99 in Excel](https://geekexcel.com/excel-formulas-to-round-a-price-to-end-in-x-99/)**. 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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Round prices to end in .45 or .95](https://geekexcel.com/wp-content/uploads/2021/04/Round-prices-to-end-in-.45-or-.95.png)](https://geekexcel.com/excel-formulas-to-round-prices-to-end-in-x-45-or-x-95-easy-guide/round-prices-to-end-in-45-or-95/#main)<figcaption id="caption-attachment-34755">Round prices to end in .45 or .95</figcaption

## General Formula:

- Use the below formula to a price value to end in .45 and .95 in Excel.

**=[CEILING](https://geekexcel.com/how-to-use-excel-ceiling-function-in-office-365-with-examples/)(price,0.5)-0.05**

## Syntax Explanations:

- **CEILING ** – In Excel, the [**CEILING function**](https://geekexcel.com/how-to-use-excel-ceiling-function-in-office-365-with-examples/) 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**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-28.png)<figcaption id="caption-attachment-34757">Input Ranges</figcaption>

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

[![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/04/Enter-the-formula-18.png)](https://geekexcel.com/excel-formulas-to-round-prices-to-end-in-x-45-or-x-95-easy-guide/enter-the-formula-93/#main)<figcaption id="caption-attachment-34756">Enter the formula</figcaption>

- Finally, we will get the result in the selected cell as shown in the below image.

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-28.png)<figcaption id="caption-attachment-34754">Result</figcaption>

## 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](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Round a Number to the Nearest Multiple Values!!](https://geekexcel.com/excel-formulas-to-round-a-number-to-the-nearest-multiple-values/)**
- **[Excel Formulas to Get Integer Part of a Number ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-get-integer-part-of-a-number/)**
- **[Formulas to Rank Items with One or more Criteria!!](https://geekexcel.com/excel-formulas-to-rank-items-with-one-or-more-criteria/)**
- **[Excel Formulas to Highlight the Alternating Groups of N Rows!!](https://geekexcel.com/excel-formulas-to-highlight-the-alternating-groups-of-n-rows/)**