random coordinates in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
What are xmax and ymax?

Are they names?

=rand()*A1

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