Rounding

Column A has several decimal numbers.

  1. In column B, use the round function to round these to the nearest whole number. In B1, start with =ROUND(A2,0). That 0 says to leave 0 decimal places.
  2. In column C, round the A column to the nearest tenth (1 decimal).
  3. In column D, round the A column to the nearest hundredth (2 decimals).
  4. In column E, use the roundup function to round up (0 decimals).
  5. In column F, use the rounddown function to round down (0 decimals).