Using the RANDARRAY function, how do i only allow excel to choose from 10, 20, and 30 without putting numbers that have a value inbetween them?

Question

Using the RANDARRAY function, how do i only allow excel to choose from 10, 20, and 30 without putting numbers that have a value inbetween them?

Anonymous

I am so confuzzled on this matter someone please help me.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Answer 1

HansV 462.6K

For example, to create a 4x4 array containing10, 20 and/or 30:

=10*RANDARRAY(4, 4, 1, 3, TRUE)

0 comments

Share via

Using the RANDARRAY function, how do i only allow excel to choose from 10, 20, and 30 without putting numbers that have a value inbetween them?

1 answer