What I have so far is

X-Corrd. data Y-Corrd. Data Distance
Calculations
A B
C
1 From Source From Source
2 First Device First Device from Source
to First device
3 next device next device from first
device to next device
4 next device next device from next
device to next device
An so on till the last device ( MAX of 25)
What I need is to get the last entered Corrdinate and calculate the distance
back to the Source . Since the amount of devices change I don't know what I
would do to check if there are any Corrdinates less than 25 devices without
doing a huge IF statement.
the formula I am using in the distance calculation is as follows:
=IF(ISNUMBER(B5),ROUNDUP((((SQRT(((B4-B5)^2)+((C4-C5)^2)))/12)*0.2)+((SQRT(((B4-B5)^2)+((C4-C5)^2)))/12),0),0)

"ANdras" wrote:

Hi there,

what do you have so far? (suspect, accumulative sum of distance?)

Best regards,
ANdras
(Hungary)

"not bright" wrote:

I am trying to produce a wire length calulation sheet for work. The sheet so
far has 25 rows, column A&B have the corrdinates of the devices. Column C has
the formula to calculate the distance. I figured out how to get the distance
from the source to the first device then to the next until you get to the
last one. I just don't know how to get the distance back to the source.
Am I being to vauge???