0
What function rounds a number up or down to the number of digits indicated in the function?
Wiki User
∙ 13y ago
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
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
How do you use Microsoft Excel roundup?
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
What is the round function in excel used for?
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
Which is the ROUND function argument specifies the number of decimal places to round to?
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.
What is 10.245 rounds to?
The answer depends on the number of significant digits that you wish to round to.
The number of significant digits in 200.000 is?
There are six significant digits in 200.000: 2, 0, 0, 0, 0, and 0.
What is the secret whole number has three digits is a multiple of 3 rounds to 700 all digits are the same?
666
What is the mystery number rounds to 200 when rounded to the nearest hundred The sum of its digits is 10 When the number is rounded to the nearest 10 it rounds to a number whose digits have a sum of 5?
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.
Using the digits 1and 3 and 5 write a number that rounds to the number 300?
315
When the 3 digit number is rounded to the nearest hundred it rounds to 200 rounded to the nearest ten this number rounds to 200 the sum of the digits is 19 what is the number?
199
A number has three digits: 2, 2, and 8.To the nearest hundred, the number rounds to 300. What is the number?
822
When you round a number to the nearest thousand the hundreds tens and ones digits become zero shouldn't that mean that the rounded number is less than the original number?
Not always because 2543 rounds to 3000 but 2345 rounds to 2000
What hand gun has 8 builts in a clip?
The number of rounds a magazine holds is a function of the magazine, not a function of the gun. Many 1911 magazines hold 8 rounds, a few Sig magazines hold 8 rounds, and there are others.
