We want the number 256.423 to be rounded to one decimal place.
We use the following formula:
round(256.423,1) ----->>>>answer is 256.42
How to round to 2 decimals in Excel?
We want the number 256.423 to be rounded to two decimal place.
We use the following formula:
round(256.423,2) ----->>>>answer is 256.4
ROUND function
The ROUND function is one of the math functions of Excel.
It Rounds a number to a specified number of digits.
ROUND arguments
This function has just 2 Argument.
The argument of ROUND function is number.
Number Is the number you want to round.
Num_digits Is the number of digits to which you want to round.
The argument of ROUND function is required and not optional.
ROUND(number) = number