RandBetween()
This function returns a random number between a given range of integer numbers
Syntax:
= Randbetween (Bottom_number, Top_number)
Bottom_number: The smallest number that the function will return
Top_number: The largest number that the function will return
Example:
= Randbetween (3,100)
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
Sunday, June 21, 2009
Function RandBetween()
RandBetween()
This function returns a random number between a given range of integer numbers
Syntax:
= Randbetween (Bottom_number, Top_number)
Bottom_number: The smallest number that the function will return
Top_number: The largest number that the function will return
Example:
= Randbetween (3,100)
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
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment