Randbetween : only by tens

[itselflearn]

Hi. How can I use Randbetween to generate numbers by tens. Example:

Randbetween(100, 999)

i would like the above formula to generate only nummbers by tens like 10, 20, 30 120, 110, 990,...and so on. Thank you.

[jeffreybrown]

How about...

=FLOOR(RANDBETWEEN(100,999),10)

[Jonmo1]

Perhaps

=RANDBETWEEN(1,99)*10

[Ace_XL]

A few more using the ROUND functions

=ROUND(RANDBETWEEN(100,994),-1)

=ROUNDDOWN(RANDBETWEEN(100,999),-1)

=ROUNDUP(RANDBETWEEN(91,990),-1)

[itselflearn]

Thank you JeffreyBrown. Your formula gives the right result. Thank you also Jonmo1 and Ace_XL for their time and sharing knowledge. I appreciated them all.