If you want to be more specific as to whether a cell figure is rounded up or down in Excel, there are two extra formulas that can be used rather than Round.

Type this formula in to the cell: =roundup(Al/ A2,2)The first part of the formula before the comma is the number or calculation to be rounded, and the second number is the number of digits that it will be rounded to. If this is zero the whole number above will be used. A positive figure will include extra decimal places, for example 3.14 and a negative figure will round up further from the decimal place for example 31500 from 31415.

Use rounddown(A 1/ A2,2) to round down with the same controls.