Post by nShrestha on Dec 23, 2013 13:32:46 GMT 5.75
RAND allows user to get a random number which can be used to select sample for the audit universe.
Syntax:
= RAND()
RANDBETWEEN allows user to get series of random numbers from the range of integer. That can be random numbers from 1-100
Syntax:
=RANDBETWEEN(bottom, top)
where,
bottom = it is the smallest integer of RANDBETWEEN range.
top = it is the highest integer of RANDBETWEEN range.
Example: =RANDBETWEEN(1,100)
Syntax:
= RAND()
RANDBETWEEN allows user to get series of random numbers from the range of integer. That can be random numbers from 1-100
Syntax:
=RANDBETWEEN(bottom, top)
where,
bottom = it is the smallest integer of RANDBETWEEN range.
top = it is the highest integer of RANDBETWEEN range.
Example: =RANDBETWEEN(1,100)