Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I am trying to get a formula to produce a distance in feet
Example: A B C X corrd y corrd 1 6806.9 1680.62 2 7243.67 1509.92 (Dist. Between a1 & a2) 3 6751.07 1319.53 (Dist. Between a2 & a3) The numbers are X & Y Coordinates for devices in a CAD program. I have a formula that I was trying: (ABS(A1-A2)+ABS(B3-B2))/12) But the results dont match to the distance in the CAD drawing. Or, are my math skills that bad??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
complex calculations | Excel Discussion (Misc queries) | |||
Calculations based on PivotTable information | Excel Discussion (Misc queries) | |||
count distance in column | Excel Worksheet Functions | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
time interval calculations in excel | Excel Discussion (Misc queries) |