I have a formula to generate a random number between 0 and 10.
.![]()
=Round(RAND() * ((10 - 1) + 1), 2)
I only need a number between 3 and 10 and can't figure out how to modify the formula for this. Any help to modify code is appreciated. Thanks.
I have a formula to generate a random number between 0 and 10.
.![]()
=Round(RAND() * ((10 - 1) + 1), 2)
I only need a number between 3 and 10 and can't figure out how to modify the formula for this. Any help to modify code is appreciated. Thanks.
Last edited by maacmaac; 05-05-2009 at 11:07 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks