Calculate the number of hexes between two hexes on a hex grid?

Question

Using the hexgrid and coordinates above, I am trying to find a consistent formula to calculate the distance between two hexes.

Also, have you seen: https://stackoverflow.com/a/40565993/4294399 — General Grievance, May 11 '22 at 19:12
share a copy / sample of your sheet with an example of the desired output — player0, May 11 '22 at 19:58

score 1 · Accepted Answer · answered May 11 '22 at 19:29

1

Switched from my x,y to q,r,s coordinates by

q=x
r=y-(x+(ISODD(x)))/2
s=-r-q

then used this formula:

=max(abs(q1-q2) + abs(r1-r2) + abs(s1-s2)) / 2

hopefully this helps someone using an even-q grid

answered May 11 '22 at 19:29

plerpsandplerps

1 Answers1