calculating the distance between cells in excel

[M8KWR]

The only way i can explain this is if you think of a chess board, you have a set amount of grids.

I would like a formula to be able to calculate the distance between to cells, is this possible????

Lets say i wanted to know the distance between cells C4 & h7...

many thanks for any help in advance.

 

[GlennUK]

What do you mean? Do you mean the length of a hypothetical straight line between the cells?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[M8KWR]

yes, or something like that, is this possible????

 

[infinitelo]

If i understand you correctly...

=ROW(H7)-ROW(C4) + COLUMN(H7) - COLUMN(C4)



if it is to be it's up to me

 

[M8KWR]

no, i need to go in a straight line, and work out the distance as the crow fly's

 

[GlennUK]

Assuming the distance from cell to cell is 1, then the distance in a straight line is =SQRT((ROW(H7)-ROW(C4))^2 + (COLUMN(H7) - COLUMN(C4))^2)

i.e. getting the hypotenuse of the triangle formed by the 2 points and a right angle.


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.