Excel Function

RANDBETWEEN

Returns random integer between two numbers.

RANDBETWEEN(bottom, top)

Arguments

bottom

Required

Enter a numeric value.

top

Required

Enter a numeric value.

Practice Preview

display numeric calculation results. Use RANDBETWEEN to Returns random integer between two numbers. use 1 for bottom, use 100 for top. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=RANDBETWEEN(1, 100)

Practice This Function

Practice in Sequential Mode Back to Function List