How to use round off formula in excel?

Asked By:
3 answer(s)
Answer # 1 #

I learned this from Microsoft support page: https://support.microsoft.com/excel-round. Very clear examples are given there.

[2 Month]
(2)
Answer # 2 #

Other related formulas: - ROUNDUP(12.34, 1) → 12.4 - ROUNDDOWN(12.39, 1) → 12.3 - INT(12.9) → 12 So depending on your need, use the correct function.

[2 Month]
(2)
Answer # 3 #

In Excel, the function is ROUND. Example: =ROUND(12.3456, 2) → gives 12.35 (rounded to 2 decimals). First argument = number, second = number of digits.

[2 Month]
(0)

More Questions