random coordinates in excel?

K

kh

I would like to know how to generate random coordinates on a map in excel. I
have tried to use the formula =rand()*xmax and =rand()*ymax but they don't
work. Do I need a later version of excel or have I got the formula wrong?
 
D

Dave Peterson

What are xmax and ymax?

Are they names?

=rand()*A1

will multiply whatever is in A1 by a random number between 0 and 1.
 
Top