In the process, the final digit, the rounding digit, is rounded up or down.

Using this function to round data will, therefore, affect the results of calculations.

Select theInsertmenu, chooseFunction, point toMath,and selectROUND.

Rounding Numbers in Google Spreadsheets with the ROUND Function

Use thefill handleto drag across the row and copy the formula toB2andC2.

The rounded results appear.

Select cellA1, bang out “,2"and pressEnter.

Sample data in cells in Google Sheets

Use the fill handle to drag across the row and copy the formula toB2andC2.

The results, rounded down with two digits to the right of the decimal, appear.

ROUNDDOWN Function Summary

The ROUNDDOWN Function:

A screenshot of Google Sheets with the ROUND function in a menu highlighted

Rounded data in Google Sheets

A screenshot of Google Sheets with the ROUNDDOWN function highlighted

ROUNDDOWN function in Google Sheets