LET function - Zoho Sheet - Help Guide

LET

Allows defining of names, values and calculations within the function. These names can only be used within the formula.

 

Syntax

 

LET(name, value, cal_or_name, [value], [cal_or_name], [value2], [cal_or_name2]...)

name: The names to which you can assign values to.

value: The values assigned to the respective names.

cal_or_name: Indicates the calculation to be performed or the next name to be defined. If calculation, it must be the last parameter in the function. If name, the respective value and calculation must be added.

 

Remarks

  • The last parameter in the function must contain the calculation that returns the result.


Examples

 

Formula

=LET(revenue;SUMIF(C:C;I1;F:F);commission;revenue*10%;revenue-commission)


Get a hands-on experience of the function in the embedded range below.              



Possible Errors

 

Errors

Meaning

#N/A!

  • The function could not find the value it was asked to look for. Commonly occurs in VLOOKUP and similar functions.

#NAME!

  • The function name is incorrect or invalid.

  • The given defined name (if any) is invalid.

  • There is a typo in the defined name used in the function.

  • Double quotes are missing for text values in the function.

  • Colon missing in a cell range reference.

#VALUE!

  • The given argument's data type is incorrect or invalid.
    For example, the function =DATE(A1:A3) will return a #VALUE error when a text value is present in the range.

#REF!

  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.