How to Round Percentages in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 6, 2023
Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to round percentages in Excel and Google Sheets.

round percentages

 

Rounding Percentages

To round numbers in Excel (or Google Sheets), you can use the ROUND Function. When using the ROUND Function you enter the number to round, followed by the number of digits to round the number.

=ROUND(A2,B2)

Round

This works exactly the same with percentages, however you must remember that a percentages are stored as decimal values. Example: 57.4% is equal to .574:

Value Percentage

So to round percentages we must keep in mind it’s decimal value. To round to the nearest whole percentage use the ROUND Function with num_digits = 2.

=ROUND(A2,2)

Round 2 Decimal

To round a percentage to 1 decimal place, we will set num_digits = 3.

=ROUND(A2,3)

Round 3 Decimal

ROUNDUP Function

You can also round up a percentage.

=ROUNDUP(A2,2)

RoundUp

ROUNDDOWN Function

Or round down a percentage.

=ROUNDDOWN(A2,2)

Round Down

Round Percentages in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

Percentage Google

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List