Round a number to a significant digit above 0

Round a number to a significant digit above 0

To do this task, use the ROUND, ROUNDUP, ROUNDDOWN, LEN, and INT functions.

EXAMPLE

The example may be easier to understand if you copy it to a blank worksheet.

How to copy an example

1 2 3

A Data 5492820 22230 Formula Description (Result) =ROUND(A2,3-LEN(INT(A2))) Rounds the top number to 3 significant digits (5490000) =ROUNDDOWN(A3,3-LEN(INT(A3))) Rounds the bottom number down to 3 significant digits (22200) =ROUNDUP(A2,5-LEN(INT(A2))) Rounds the top number up to 5 significant digits (5492900)

Categories: ROUND