How to add rounding to a formula in excel?

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

To round values in Excel, use the ROUND function:

[3 Month]
(2)
Answer # 2 #

You can also use ROUNDUP or ROUNDDOWN to control the direction of rounding.

[2 Month]
(2)
Answer # 3 #

Example: =ROUND(A1, 2) rounds the value in cell A1 to 2 decimal places.

[3 Month]
(1)

More Questions