Similar and Alternative Excel Functions to LET

Similar and Alternative Excel Functions to LET

Categories
undefined
  •  SEQUENCE belongs to the Mathematical category. 👍 undefined.  SEQUENCE performs Calculation operations.  SEQUENCE needs 1 required arguments 👎 LET needs fewer arguments than SEQUENCE.
  •  LAMBDA belongs to the Engineering category. 👉 undefined.  LAMBDA performs Calculation operations.  LAMBDA needs 1 required arguments 👎 LET needs fewer arguments than LAMBDA.
  •  COUNTIF belongs to the Statistical category. 👍 undefined.  COUNTIF performs Aggregation operations.  COUNTIF needs 2 required arguments 👉 LET needs same number of arguments as COUNTIF.
  •  XLOOKUP belongs to the Lookup & Reference category. 👍 undefined.  XLOOKUP performs Retrieval operations. 👍 undefined.  XLOOKUP needs 3 required arguments 👍 XLOOKUP needs fewer arguments than LET.
  •  CONCATENATE belongs to the Text category. 👍 undefined.  CONCATENATE performs Manipulation operations. 👉 undefined.  CONCATENATE needs 2 required arguments 👉 LET needs same number of arguments as CONCATENATE.
  •  FILTER belongs to the Database category.  FILTER performs Manipulation operations. 👉 undefined.  FILTER needs 2 required arguments 👉 LET needs same number of arguments as FILTER.
  •  SUMPRODUCT belongs to the Mathematical category. 👍 undefined.  SUMPRODUCT performs Calculation operations.  SUMPRODUCT needs 2 required arguments 👉 LET needs same number of arguments as SUMPRODUCT.
  •  MATCH belongs to the Lookup & Reference category. 👍 undefined.  MATCH performs Retrieval operations. 👍 undefined.  MATCH needs 3 required arguments 👍 MATCH needs fewer arguments than LET.
  •  FIND belongs to the Mathematical category. 👍 undefined.  FIND performs Manipulation operations. 👉 undefined.  FIND needs 2 required arguments 👉 LET needs same number of arguments as FIND.
  •  SUBTOTAL belongs to the Mathematical category. 👍 undefined.  SUBTOTAL performs Aggregation operations.  SUBTOTAL needs 2 required arguments 👉 LET needs same number of arguments as SUBTOTAL.