pwrRANDFROMRANGE

PowerUp Description

The pwrRANDFROMRANGE PowerUp function returns the value in a randomly selected cell from the range provided.

PowerUp Syntax

pwrRANDFROMRANGE(range)

The pwrRANDFROMRANGE PowerUp function has the following arguments:

range– Required. This is the range of cells from which to select the random cell.

Return Value

pwrRANDFROMRANGE will return the value from one of the cells in the range.

Remarks

The range may have multiple rows and columns. In other words, it can be two dimensional.

Example

=pwrRANDFROMRANGE(A1:Z20)

Leave a Reply

Your email address will not be published. Required fields are marked *