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?

Anonymous
2024-03-06T19:59:03+00:00

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

Microsoft 365 and Office | Excel | For education | Windows

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 No comments

1 answer

Sort by: Most helpful
  1. HansV 462.6K Reputation points
    2024-03-06T20:04:09+00:00

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

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

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments No comments