Round a price to end in .99

Round a price to end in .99

Related Functions


If you need to round prices so that they ended in the nearest, .99 value, you can use the ROUND function then subtract .01.

How this formula works

The formula shown in the example is:


With the value in B6 of 69.23, the formula is solved like this:

=ROUND(B6,0)-0.01 =ROUND(69.23,0)-0.01 =69-0.01 =68.99

The ROUND function with a zero will round to the nearest whole dollar. Once rounded, the formula simply subtracts 0.01 to get a .99 value.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas