Explanation
The ExcelCEILING functionrounds a numberupto 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 $35.00, since 35 is the next multiple of 5 after 33.39.
CEILING roundsupusing the multiple supplied.
you might use theMROUND functionto round to thenearest multipleand theFLOOR functionto rounddownto a multiple.
CEILING works like theMROUND function, but CEILINGalways rounds up.
