ROUNDSIG

Rounds a number to a specified number of significant figures.

Syntax

ROUNDSIG(number, num_digits)

number - is the number you want to round.

num_digits - specifies the number of significant figures to which you want to round number.

Remark

Examples

ROUNDSIG(149.149, 1) equals 100

ROUNDSIG(149.149, 2) equals 150

ROUNDSIG(149.149, 3) equals 149

ROUNDSIG(149.149, 4) equals 149.1

ROUNDSIG(149.149, 5) equals 149.15

ROUNDSIG(149.149, 6) equals 149.149