Several Excel formulas deal with rounding and precision of non-integer numbers. This is separate from using cell formatting that affects the display of numeric data. In some cases just using cell formatting is sufficient, but in complex calculations, strict rules for rounding and precision are required to obtain consistent and correct results.

- =ROUND(number, num_digits)
- =ROUNDUP(number, num_digits)
- =ROUNDDOWN(number, num_digits)
- =MROUND(number, multiple)
- =TRUNC(number, [num_digits])
- =INT(number)
- =CEILING(number, significance)
- =FLOOR(number, significance)
- =EVEN(number)
- =ODD(number)
- =FIXED(number, [decimals], [no_commas])

Parameters | Details |
---|---|

number | number to be rounded. Could be a cell like B2 or a constant like 3.14159 |

num_digits | which place to be rounded 2. Omitted or 0 means round to a whole number. 1 or 2 means round to tenths or hundredths. -1 or -3 means round to tens or thousands. |

multiple | The multiple to which you want to round number. |

significance | The multiple to which you want to round number. |

decimals | The number of digits to the right of the decimal point. (Optional - defaults to 2) |

no_commas | A logical value that, if `TRUE` , prevents `FIXED` from including commas in the returned text. (Optional - defaults to `FALSE` ) |

[ ... ] | Parameters in [square brackets] are optional. |

The values displayed to the user can be presented with specific formatting that does not affect the actual data values. For example, displayed data could be formatted as a percentage. See Cell Formatting for details.

This modified text is an extract of the original Stack Overflow Documentation created by following contributors and released under CC BY-SA 3.0

This website is not affiliated with Stack Overflow