53 Excel Functions better than LET

53 Excel Functions better than LET

Categories
List of Excel functions rated better than LET based on overall score
Facts about Excel Functions better than LET
  •  COUNTA belongs to the Statistical category.  COUNTA performs Calculation operations.  COUNTA needs 1 required arguments
  •  SUMPRODUCT belongs to the Mathematical category.  SUMPRODUCT performs Calculation operations.  SUMPRODUCT needs 2 required arguments
  •  SUM belongs to the Mathematical category.  SUM performs Calculation operations.  SUM needs 1 required arguments
  •  ROUND belongs to the Mathematical category.  ROUND performs Calculation operations.  ROUND needs 2 required arguments
  •  XLOOKUP belongs to the Lookup & Reference category.  XLOOKUP performs Retrieval operations.  XLOOKUP needs 3 required arguments
  •  IF belongs to the Logical category.  IF performs Comparison operations.  IF needs 3 required arguments
  •  CHOOSE belongs to the Logical category.  CHOOSE performs Manipulation operations.  CHOOSE needs 2 required arguments
  •  INDEX_MATCH belongs to the Lookup & Reference category.  INDEX_MATCH performs Retrieval operations.  INDEX_MATCH needs 3 required arguments
  •  CONCAT belongs to the Text category.  CONCAT performs Manipulation operations.  CONCAT needs 2 required arguments
  •  UNIQUE belongs to the Database category.  UNIQUE performs Aggregation operations.  UNIQUE needs 1 required arguments
  •  FILTER belongs to the Database category.  FILTER performs Manipulation operations.  FILTER needs 2 required arguments
  •  TRANSPOSE belongs to the Lookup & Reference category.  TRANSPOSE performs Manipulation operations.  TRANSPOSE needs 1 required arguments
  •  HYPERLINK belongs to the Web category.  HYPERLINK performs Information operations.  HYPERLINK needs 2 required arguments
  •  EOMONTH belongs to the Date & Time category.  EOMONTH performs Calculation operations.  EOMONTH needs 2 required arguments
  •  SEQUENCE belongs to the Mathematical category.  SEQUENCE performs Calculation operations.  SEQUENCE needs 1 required arguments
  •  COUNTBLANK belongs to the Statistical category.  COUNTBLANK performs Calculation operations.  COUNTBLANK needs 1 required arguments
  •  ISBLANK belongs to the Information category.  ISBLANK performs Comparison operations.  ISBLANK needs 1 required arguments
  •  COUNT belongs to the Mathematical category.  COUNT performs Calculation operations.  COUNT needs 1 required arguments
  •  SORT belongs to the Database category.  SORT performs Manipulation operations.  SORT needs 1 required arguments
  •  MAX belongs to the Mathematical category.  MAX performs Calculation operations.  MAX needs 1 required arguments
  •  AVERAGE belongs to the Statistical category.  AVERAGE performs Calculation operations.  AVERAGE needs 1 required arguments
  •  OR belongs to the Logical category.  OR performs Comparison operations.  OR needs 2 required arguments
  •  MIN belongs to the Mathematical category.  MIN performs Calculation operations.  MIN needs 1 required arguments
  •  AND belongs to the Logical category.  AND performs Comparison operations.  AND needs 2 required arguments
  •  SUBSTITUTE belongs to the Text category.  SUBSTITUTE performs Manipulation operations.  SUBSTITUTE needs 3 required arguments