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?