Hi Adam,

I don't understand what you have and what you're trying to calculate.
If you have two legs, you have three points, haven't you? So you can
calculate the third leg the same way.
Please explain a bit more and give an example

--
Kind regards,

Niek Otten

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
I am trying to develop a formula so that Excel can calculate the range for
a wargame. The game is called Battletech if you know what it is. It is
played on a map that has a hex grid measuring ~3/4" a side. The hexes are
numbered (4 digit 01 - 15 accross and 01 - 17 up top left is numbered 1001
bottom right 1517 The map is 15x17 ) so I am able to give Excel the
position of each unit on the map. and calculate 2 legs of a triangle, but
it is not always a right triangle (I struggled with it for 3 days before I
realized wy a^2+b^2=c^2 wasn't working.... It has been almost 20 years
since I took a geometry class.....

Thanks in advance for any help I can get.

Adam