Function Rand()

Rand()

This function returns an evenly distributed random number between 0 and 1



Syntax:

=
Rand ()

Note: This function is a volatile function, i.e. this function is re-calculated whenever the worksheet gets updated. A heavy use of this function in a workbook can make your workbook calculations slow.

In Excel 2007, there is also an advanced version of this function:
Randbetween()

Share on Google Plus

About Rishie Khurana

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Sunday, June 21, 2009

Function Rand()

Rand()

This function returns an evenly distributed random number between 0 and 1



Syntax:

=
Rand ()

Note: This function is a volatile function, i.e. this function is re-calculated whenever the worksheet gets updated. A heavy use of this function in a workbook can make your workbook calculations slow.

In Excel 2007, there is also an advanced version of this function:
Randbetween()

Function Rand()SocialTwist Tell-a-Friend

0 comments:

Post a Comment