convert yards

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know a fomula or function to convert yards to miles and yards
i.e. 2000 yards equals 1 mile and 240 yds not 1.14 miles.
Thanks
 
=TRUNC(A1/1760)&" Miles "&MOD(A1,1760)&" Yards"

or if you wanted it to be slightly more elaborate
=IF(A1<1760,A1& " yards",IF(A1<3520,TRUNC(A1/1760)&" Mil
"&MOD(A1,1760)&" Yards",TRUNC(A1/1760)&" Miles "&MOD(A1,1760)&
Yards"))

Regards

Da
 
Back
Top