So, for example, if a price is currently $5.31, the result should be $4.99.

Once rounded, the formula simply subtracts 0.01 to get a .99 value.

The ROUND function can round to the right or left of the decimal point.

Excel formula: Round price to end in .45 or .95

MROUND Function

The Excel MROUND function returns a number rounded to a given multiple.

MROUND will round a number up or down, depending on the nearest multiple.

Excel formula: Round a number to nearest multiple

Excel formula: Round time to nearest 15 minutes

Excel ROUND function

Excel MROUND function