The MAP Function

The MAP function allows for users to apply logic or other functions across a range of cells.
Typical use cases are if you tend to drag a formula across an entire column or row creating many formula cells. You may use MAP to create a singular formula cell that affects the entire range. An example would be

If we used

=MAP(A1:A3,LAMBDA(cell,cell+1))

in the cell B1 we would get

When using map the LAMBDA(variable, variable can be named anything you would like
Map supports up to any number equally sized arrays for example

if we use

=MAP(A1:A3,B1:B3,C1:C3,lambda(a,b,c,a+b+c))

In D1 it will return