This function rounds the number, according to the significant figures entered.
Round([Number], [Significant Figures])
Where:
Number is the number to round.
Significant Figures is the number of significant figures to keep.
Rule | Meaning |
|---|---|
| RoundSF(29648, 1) | Will round the number to the first significant figure and return 30000. |
| RoundSF(29648, 3) | Will round the number to the third significant figure and return 29600. |
| RoundSF(29648, 4) | Will round the number to the fourth significant figure and return 29650. |
| RoundSF(0.056, 1) | Will round the number to the first significant figure and return 0.06.
The leading zeros are not significant figures. |
| RoundSF(15600,2) | Will round the number to the second significant figure and return 16000. |