Try the ROUND function.
ROUND(number,num_digits)
For example,
=ROUND(101.52,-1) yields: 100
=ROUND(101.52,0) yields: 102
=ROUND(101.52,1) yields: 101.5
RoundUp function returns a number rounded up to a specified number of digits. (Rounds away from 0.)Syntax: RoundUp( number, digits )number = number to round updigits = number of digits to round the number up to
ROUND is a function that returns a number rounded to a specified number of digits.Syntax: =ROUND( number, digits )number is the number to rounddigits is the number of digits to round the number toEXAMPLES:=ROUND(1/3,2) will return 0.33=ROUND(1/6,2) will return 0.17
In Excel, the second argument of the Round function specifies the number of decimal places to round to. If this number is negative, it rounds to corresponding digits before the decimal point.
The answer depends on the number of significant digits that you wish to round to.
201 .601 rounds to; .6 .6 rounds to 1 Thus; 200.601 => 201
666
The mystery number is 155. When rounded to the nearest hundred, it rounds to 200. The sum of its digits is 1+5+5=11 which is greater than 10, so we must adjust the digit in the hundreds place. When rounded to the nearest ten, 155 rounds to 160, which has digits summing up to 1+6+0=7.
315
199
822
The number you are describing is 86. When rounded to the nearest tenth, 86 becomes 90, since the tenths place (which is 6) rounds up when the next digit (which is 6 in this case) is 5 or greater. Thus, 86 meets both criteria: it has the digits 8 and 6, and rounds to 90.
Not always because 2543 rounds to 3000 but 2345 rounds to 2000