Different Ways of rounding numbers in EXCEL

You must understand the difference between rounding a value and formatting a value. When you format a number to display a specific number of decimal places, formulas that refer to that number use the actual value, which might differ from the displayed value. When you round a number, formulas that refer to that value use the rounded number

1. CEILING.MATH - Rounds a number up to the nearest specified multiple

2. EVEN - Rounds up (away from zero) positive numbers to the nearest even integer; rounds down (away from zero) negative numbers to the nearest even integer

3. FLOOR.MATH - Rounds a number down to the nearest integer or to the nearest specified multiple

4. INT - Rounds a number down to make it an integer

5. MROUND - Rounds a number to a specified multiple

6. ODD - Rounds up (away from zero) numbers to the nearest odd integer; rounds down (away from zero) negative numbers to the nearest odd integer

7. ROUND - Rounds a number to a specified number of digits

8. ROUNDDOWN - Rounds down (toward zero) a number to a specified number of digits

9. ROUNDUP - Rounds up (away from zero) a number to a specified number of digits

10. TRUNC - Truncates a number to a specified number of significant digits

2. EVEN - Rounds up (away from zero) positive numbers to the nearest even integer; rounds down (away from zero) negative numbers to the nearest even integer

3. FLOOR.MATH - Rounds a number down to the nearest integer or to the nearest specified multiple

4. INT - Rounds a number down to make it an integer

5. MROUND - Rounds a number to a specified multiple

6. ODD - Rounds up (away from zero) numbers to the nearest odd integer; rounds down (away from zero) negative numbers to the nearest odd integer

7. ROUND - Rounds a number to a specified number of digits

8. ROUNDDOWN - Rounds down (toward zero) a number to a specified number of digits

9. ROUNDUP - Rounds up (away from zero) a number to a specified number of digits

10. TRUNC - Truncates a number to a specified number of significant digits

## No comments:

## Post a Comment