=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 69.23, the formula is solved like this:
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.
