Generate random number from 1-100 inclusive?

[Ricter]

= Round(Rnd() * 100, 0)

The above code is generating random numbers from 0-100. How can I alter it
to generate only 1-100?

 

[KARL DEWEY]

Try multiple use of the function like this --
= IIf(Round(Rnd()*100,0)=0,Round(Rnd()*100,0),Round(Rnd()*100,0))

The odds of both instances comming up zero at the same time is kinda high.

 

[Ricter]

THAT was the trick, thank you. I used to know this, back in the '70s,
programming games in BASIC, lol.