Explanation
The ExcelFLOOR functionrounds a numberdownto a given multiple.
The multiple to use for rounding is given as the second argument (significance).
If the number is already an exact multiple, no rounding occurs.
The result is $30.00, since 30 is nearest multiple of 5 below 33.39.
FLOOR roundsdownusing the multiple supplied.
it’s possible for you to use theMROUND functionto round to thenearest multipleand theCEILING functionto roundupto a multiple.
FLOOR works like the MROUND function, but FLOORalways rounds down.
