Microsoft Office Tutorials and References

In Depth Information

**Syntax:**

Figure 11.10.

Figure 11.10.
MROUND

MROUND rounds a price to a certain multiple. Here, column D is

rounds a price to a certain multiple. Here, column D is

the calculated prices rounded to the nearest $5.

the calculated prices rounded to the nearest $5.

The multipleargument in MROUND is allowed to be negative.

In other situations, you might want to round a number up to a certain multiple.

Figure 11.11
shows a requisition list. Column A shows the quantity needed,

and column B shows the item. The purchasing agent discovered a vendor who

offers a significant discount, but only if you buy in complete case quant-

ities. Column C shows the size of the case for each product. To calculate

the total number to order, you need to round a number in column A up to the

nearest multiple of the case size found in column C. You use =CEILING(A4,C4)

to achieve this effect.