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.
Search JabSto ::




Custom Search