Using the MAP function in google sheets with a custom function with a single formula

@redtailfanschool In this short video I demonstrate how to use the MAP function in a google sheet. In this case we are using a custom function (Mileage) on a sheet. The problem I was trying to solve is having a single formula in the sheet header row to calculate the mileage between two cities.

={"Mileage"; MAP($G$2:$G, $H$2:$H, $I$2:$I, LAMBDA(start, finish, rt, IFERROR(IF(rt = "Yes", mileage(start, finish) * 2, mileage(start, finish)),)))}

The MAP formula allows me to set the three variables in a single formula.

Видео Using the MAP function in google sheets with a custom function with a single formula канала Google Sheets Tutorials