RAND function with upper and lower limits

Good morning

I am using 2003 and do not have the RANDBETWEEN funtion available.

Does anyone have a formula that will generate the random numbers but between an upper and lower limit? eg In some cases I want to limit it to between 80% and 100%.

Thanks in advance

Darren

you can get 80 to 100 with

=INT(RAND()*21+80)

If you want that to be a percentage just divide by 100, i.e.

=INT(RAND()*21+80)/100