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

About this lesson

@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.

Original Description