Best Answer

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.

User Avatar

Wiki User

โˆ™ 2014-07-11 19:20:19
This answer is:
User Avatar
Study guides

Steel Tip Darts Out Chart

96 cards





See all cards

Math and Arithmetic

20 cards

What is the term for the relationship between the distance on the map and actual distance on earth's surface

How do you write a ratio as a fraction in simplest form

Convert gallons per hour to gallons per minute

How do you convert meters per minute to feet per minute

See all cards

Chemical Elements | Symbols | and Atomic Numbers

10 cards





See all cards

Add your answer:

Earn +20 pts
Q: Which is the ROUND function argument specifies the number of decimal places to round to?
Write your answer...
Related questions

What is the function of BEL?

BEL is simply the decimal equivalent of the number 7, and the function of BEL is to show the number 7.

What is function overloading?

Function overloading is a means of providing alternative implementations of the same function according to the number and type of argument passed to it.

A function prime that returns if its argument is a prime no or returns zero?

prime number

What is the meaning of tangent theta?

It is a trigonometric function whose argument is the number theta.

When to use arguments in function?

You declare one or more function arguments whenever a function requires the caller to specify one or more values for the function to operate upon. For instance, a function that calculates the square root of a number needs to know which number to operate upon: float sqrt(float num); float x = sqrt(25); Here, the value 25 is assigned to the function argument named num. Thus the function can access the value passed by the caller (the actual argument) via the num variable (the formal argument). As far as the function is concerned, num is just a local variable like any other. But, because it is also an argument, the caller can initialise it with any suitable value.

Does the NUMBER function return the number of cells in the range indentified in the argument contain data?

No. In Excel you would use the COUNT function to do it, or possibly the COUNTA or COUNTIF, depending on exactly what you were trying to do.

What is the difference between argument and parameter?

In programming there is no difference. Some languages prefer you to use one or the other, however this is merely by convention; the terms are interchangeable and do not affect the meaning in any way. In programming, we use the terms formal argument and actual argument. The actual argument is the argument being passed to the function. The actual argument may be a named variable or a literal constant. The formal argument is the corresponding argument that is used by the function. When we pass an argument to a function, the actual argument's value is assigned to the formal argument of the function. This is known as pass by value. However, if we pass a memory address (by value), this is known as pass by reference.In mathematics there is a subtle difference between the terms. Mathematical functions may accept any number of arguments composed of variables. However, a function may use additional variables that are not themselves passed as arguments to the function. These variables are known as the function's parameters. In programming, we would call these variables local variables rather than parameters.

What is the INT function in programming?

The INT function is to convert something into an integer. An integer is a number that goes out two decimal places.

What is the definition of function rule?

A function, in mathematics, associates one quantity, the argument of the function, also known as the input, with another quantity, the value of the function, also known as the output. A function assigns exactly one output to each input. The argument and the value may be real numbers, but they can also be elements from any given set. An example of a function is f(x) = 2x, a function which associates with every number the number twice as large. Thus 5 is associated with 10, and this is written f(5) = 10.

Which function removes a decimal part of a number on excel?

Int(number) removes itRound(number,0) rounds the decimal fraction to the nearest whole number.

What is implied by the argument of the function?

A function (also known as procedure, subroutine, and - in object-oriented languages - as a method) lets you do repetitive calculations in a single place, without having to repeat lots of commands over and over. For example, you might have a function that calculates the square root of a number. An argument (also known as a parameter) is any variable information you pass to your function. For example, in the case of calculating a square root, the argument tells the function what number you want to calculate the square root of. For calculating powers, you might have two arguments: the base, and the exponent. In general, a function can have zero or more arguments - it really depends what it is used for.

What is a round function in Excel?

A round function can round a number up or down to show with a set amount of decimal places. The ROUND function rounds to the nearest value. The ROUNDUP function always rounds a number up and the ROUNDDOWN function always rounds down. They all take the same arguments, which are the value you want to round and the amount of decimal places to display. For example: =ROUND(6.7541,2) will round 6.7541 to 2 decimal places and display 6.75 as the result.

What is a number that contains a decimal point?

It is a number with a decimal point. It is not necessarily a decimal number because 24 (no decimal pont) is a decimal number.It is a number with a decimal point. It is not necessarily a decimal number because 24 (no decimal pont) is a decimal number.It is a number with a decimal point. It is not necessarily a decimal number because 24 (no decimal pont) is a decimal number.It is a number with a decimal point. It is not necessarily a decimal number because 24 (no decimal pont) is a decimal number.

Write a Program to convert decimal number into hexadecimal no without using function and string?

This is not a question.

In cases ROUND(219.890)CEILING(219.890) the output will be 220?

In order to get 220 for each of those, another argument must be added to each function. For the ROUND function, you could specify the number of decimal places: =ROUND(219.890,0) CEILING requires that you specify the amount of significant digits, so we need 1. =CEILING(219.890,1)

What is a number that specifies certain properties of electrons?

quantum number

Is 1.7 an integer?

No, it is a decimal number.

What is the use of decrease decimal in excel?

This function has to do with the format of a cell and how many decimal places are shown. Applies only to numbers. Keep in mind that the actuall value is unchanged. For example, the number will be rounded if you specify 0 decimal places.

How do you round off number in Microsoft Excel?

Use the function = round(number, num_digits).Number is the number that you want to round; and num_digits is the number of digits that you want to round to. A positive number rounds to that number AFTER the decimal point, a zero rounds TO the decimal point and a negative number rounds to BEFORE the decimal point.There are similar functions ROUNDUP and ROUNDDOWN, functions that do what their names suggest.

What is the function for rounding off numbers?

In Excel, the function is Round(number, num_digits) wherenumber is the number that you want to round,andnum_digits is the number of digits after the decimal point that you want.If num_digits < 0 then the number is rounded to that many digits to the left of the decimal point.

What is datetypes?

datatype is a classification describing the type of the data. Eg:- Datatypes like float specifies the data to be floating point number, integer specifies the data to be a real number. It also specifies the possible values, default values, operations that can be carried on them.

Why we use percent you in c language?

%u is a printf format specifier that says to take the next argument and display it as an unsigned decimal number, assuming standard integer length.

Is 5.3 a natural number?

5.3 is not a natural number. Because, it is a decimal

How do you write 99 cents in decimal form?

$0.99 * * * * * I disagree. The above answer is 99 hundredths of a dollar. That happens to be 99 cents but what if the question were in terms of Euro-cents? The decimal form is simply a way of representing a number - irrespective of how it might look in other units UNLESS the question specifies that the decimal form should be in the context of the other unit (dollar, Euro or whatever). Therefore, the correct answer is that 99 cents, in decimal form is simply 99 cents.

Can a decimal number be a whole number?

No. A whole number is a number with no fractional (decimal) part. Therefore a decimal number can not be a whole number. Another view: 35.0 is a whole number AND a decimal. The fact that a number is a decimal does not automatically require it to have a fractional part. Even 35 is a decimal number (without a decimal point).