northgwinnett02
New member
here is what I want to happen plug in for x plug in for y (your coordinates)and come out with z to show for multiple entries(distance formula to be exact) for like 100 different locations. is there a way I can do this. I have an excel formula but have had no luck. In my case the formula was as follows
=SQRT ((POWER (IF((ABS(A2-$C$1)) >375,750-(ABS (A2-$C$1)), (A2-$C$1)),2)) +POWER( I
F((ABS( B2-$C$1))>375,750- (ABS(B2-$C$1)) ,(B2-$C$1)) ,2))
=SQRT ((POWER (IF((ABS(A2-$C$1)) >375,750-(ABS (A2-$C$1)), (A2-$C$1)),2)) +POWER( I
F((ABS( B2-$C$1))>375,750- (ABS(B2-$C$1)) ,(B2-$C$1)) ,2))