0
ROUND is a function that returns a number rounded to a specified number of digits.
Syntax: =ROUND( number, digits )
number is the number to round
digits is the number of digits to round the number to
EXAMPLES:
=ROUND(1/3,2) will return 0.33
=ROUND(1/6,2) will return 0.17
Wiki User
∙ 14y ago
Wiki User
∙ 13y agoThe ROUND function returns a number rounded to a specified number of digits.
Syntax: ROUND(number,digits)
number = number to round.
digits = number of digits to round the number to.
Wiki User
∙ 8y agoThe ROUND function has just two arguments, which are the value to round and the amount of decimal places to round it to.
=ROUND( 7.391, 1 )
The result of the above would be 7.4 as it rounds the value to one decimal place.
Wiki User
∙ 7y agoA 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.
Add your answer:
Earn +20 pts
What is used to ensure totals are exactly correct to the nearest penny in Excel?
round function
How do I add round to a formula in Excel to show no decimal places in Excel?
There is a function called ROUND which you can use to round to zero decimal places. If your number was in cell A2, the formula would be:=ROUND(A2,0)
What kind of excel function is ROUND(AVERAGE(A1A100)2)?
=ROUND(AVERAGE(A1:A100),2) The answer you may be looking for is a nested function, as one is inside another. ROUND is a math function and AVERAGE is a statistical function.
Values used with a function in Excel?
Arguments
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.
The function is the most frequently used type of function formula?
The SUM function would be the most commonly used function in Excel.
Is 8.4999 return a value of 8 in Microsoft Excel sheet?
=ROUND(8.4999,0) function will return 8.
What is an excel function used to enter the system date in a cell in a worksheet?
The NOW function
What Excel function can be used to calculate the futue value of any investment?
The FV function.
Which function can be used to check whether the value is numeric or not?
In Excel you can use the ISNUMBER() function.
Name a search function within Excel?
There is a function called FIND and a function called SEARCH in Excel. There are other functions that can be used to find things, such as the various lookup functions.
What does Excel use to separate multiple arguments in a function?
Commas are used to separate arguments in Excel functions.
