Not sure...

K

Kim

I have a formula in a workbook and I don't know what it means. Can you please
tell me what ROUND means and also the ,5 at the end of the formula?

=ROUND((Z13-AB13),5)


Thanks!
 
J

JE McGimpsey

From XL Help:

ROUND
Rounds a number to a specified number of digits.
Syntax
ROUND(number,num_digits)
Number is the number you want to round.
Num_digits specifies the number of digits to which you want to round
number.
 
V

Vergel Adriano

Kim,

It rounds the difference between the value in Z13 and AB13 to 5 decimal
places. The Excel help has a good explanation and examples. Search the help
for "ROUND worksheet function"
 
R

Ron Coderre

Re: =ROUND((Z13-AB13),5)

That formula subtracts the value in cell AB13 from the value in cell Z13 and
rounds the result to 5 decimal places.

The ROUND function is pretty well documented in Excel Help.
Is there confusion about something else?
***********
Regards,
Ron

XL2002, WinXP
 
D

David Biddulph

Excel has a help facility which explains each function (except DATEDIF), and
its syntax, and gives examples. You can either get at it through the help
window, or through the help menu, or by clicking on the hyperlink which
appears if you click on the function name in the formula, or by clicking on
the "fx" to the left of the formula window.
 
Top