Microsoft Office Tutorials and References
In Depth Information
Syntax:
Syntax:
=MROUND(number,multiple)
=CEILING(number,significance)
=CEILING.MATH(number,[significance])
=FLOOR(number,significance)
=FLOOR.MATH(number,[significance])
The last five functions in this group MROUND, CEILING, CEILING.MATH,
FLOOR, and FLOOR.MATH round a number to a certain multiple. They re-
quire you to enter the number and the multiple to which to round. They all
take the following arguments:
number
number This is the number you want to round.
multiple
significance This is the nearest multiple that you want
to round toward. Note that if numberis negative, multipleor signific-
ancemust also be negative.
Suppose that you handle pricing for a line of products. Your general rule is
to mark up the product cost, which results in a series of strange prices, such
as $185.9375, as shown in Figure 11.10 . To round each price to the nearest in-
crement of $5, you use =MROUND(C2,5). You could also use MROUND to round
to the nearest quarter: =MROUND(C2,0.25).
multipleor significance
Search JabSto ::




Custom Search