Excel LET function (365)

Description

The Excel LET function assigns names to calculation results. It allows storing calculations, values, defined names inside the formula. 

Syntax and arguments

Formula syntax

Arguments

Return Value

The LET function returns the result of the calculation.

Version

Excel 365 and Excel 2021.

Usage and Examples

Example1 one name and one name_value

Supposing, we define a name as x, and the value of x is 1, the calculation is x+1, now use them in the formula as this:

=LET(x,1,x+1)

Press Enter key.

Example2 two pairs of names and name_values

Supposing, we define the first name as x, and the value of x is 1, the second name as y, and the value of y is 2, the calculation is x+1-y+10, now use them in the formula as this:

=LET(x,1,y,2,x+1-y+10)

Press Enter key.

Other Functions:

• Excel ISODD Function
  The ISODD function checks whether a value is an odd number. If the given value is an odd number, it returns TRUE. Otherwise, it returns FALSE.

• Excel ISEER Function
  The ISERR function returns TRUE for any error type (except #N/A) and FALSE otherwise.

• Excel ISEVEN Function
  The Excel ISEVEN function tests if a supplied number (or numeric expression) is even, if so, it returns TRUE, otherwise, it returns FALSE.

• Excel ISREF Function
  The ISREF function checks whether a given value is a reference. If the given value is a reference, it returns TRUE. Otherwise, it returns FALSE.