Round a price to end in .99

An excel formula to round a price to end in .99

Related Functions

Sponsored Link

 Round a price to end in .99
=ROUND(price,0)-0.01

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:

 
=ROUND(B6,0)-0.01

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

 
=ROUND(B6,0)-0.01 =ROUND(63.39,0)-0.01 =63-0.01 =62.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.

Sponsored Link

0 votes. 0 / 5