Function 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()

RELATED POSTS

0
comments:

Post a Comment

Sunday, June 21, 2009

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()