Randbetween with steps

[rline101]

Is there any way to get a formula to return randomly chosen values from the set 1000, 2000, 3000, 4000, 5000, 6000, 7000, 8000, 9000 by using randbetween?

Or if not some other way?

Thanks

 

[Legacy 14611]

=INT(RANDBETWEEN(1,9))*1000

 

[Lewiy]

Do you mean like this?:

=CHOOSE(RANDBETWEEN(1,9),1000,2000,3000,4000,5000,6000,7000,8000,9000)

 

[Lewiy]

Or even possiblyL

=CEILING(RANDBETWEEN(0,9000),1000)

 

[rline101]

All three work fine. But the first reply is the simplest and so obviously elegant. Thanks heaps for such quick replies. Next post I'll try make it more difficult for you