random coordinates in excel?
 

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?

random coordinates in excel?
 

What are xmax and ymax?

Are they names?

=rand()*A1

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

kh wrote:

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?

--

Dave Peterson