Use the EVEN or ODD function to round up to the nearest even or odd number, respectively. The syntax for each of these functions is (number), so simply type in the number or cell reference that ...

The formula for the ROUNDDOWN function is ROUNDDOWN (number, num-digits). The syntax for the ROUNDDOWN function is below: Number: Any real number that you want to round down. It is required.

Enter "Roundup (A1,-1)" without quotes in any empty cell. Change "A1" to your actual cell reference. The "-1" in the formula tells the Roundup function to round up to the nearest ten.