Formula works fine in google sheets but not Excel

[CAB434]

When I type the two addresses i get #NAME? in E4


="http://maps.googleapis.com/maps/api/directions/xml?origin=" &B4& "&destination=" & C4 & "&sensor=false&units=imperial&region=us&language=en"


=ROUNDUP(importxml(E4,"//leg/distance/value")/1000,0)

What am I doing wrong ?

 

[CAB434]

Sorry,

I didnt mention Im using Excel Online. And Thank You.

 

[Aladin Akyurek]

Are you sure there is function IMPORTXML in Excel?

If not, you'll get a #NAME? error...

See: xml - Function Similar to importxml in Excel? - Stack Overflow