Not sure...

[Guest]

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!

 

[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.

 

[Guest]

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"

 

[Guest]

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

 

[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.