- Round a number - Microsoft Support
As a general rule, when you round a number that has no fractional part (a whole number), you subtract the length from the number of significant digits to which you want to round
- MROUND function - Microsoft Support
MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple The Number and Multiple arguments must have the same sign If not, a #NUM error is returned
- ROUNDUP function - Microsoft Support
ROUNDUP behaves like ROUND, except that it always rounds a number up If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places
- Round a number - Microsoft Support
As a general rule, when you round a number that has no fractional part (a whole number), you subtract the length from the number of significant digits to which you want to round
- ROUNDDOWN function - Microsoft Support
ROUNDDOWN behaves like ROUND, except that it always rounds a number down If num_digits is greater than 0 (zero), then number is rounded down to the specified number of decimal places
- FIXED function - Microsoft Support
Rounds the number in A2 one digit to the left of the decimal point Rounds the number in A3 one digit to the left of the decimal point, without commas (the TRUE argument) Rounds the number in A4 two digits to the left of the decimal point
|