answersLogoWhite

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

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

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.


Which function can be used to check whether the value is numeric or not?

In Excel you can use the ISNUMBER() function.


What Excel function can be used to calculate the futue value of any investment?

The FV function.


What is an excel function used to enter the system date in a cell in a worksheet?

The NOW 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.