Formulas and Functions Help
- Welcome
-
- ACCRINT
- ACCRINTM
- BONDDURATION
- BONDMDURATION
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENCYCODE
- CURRENCYCONVERT
- CURRENCYH
- DB
- DDB
- DISC
- EFFECT
- FV
- INTRATE
- IPMT
- IRR
- ISPMT
- MIRR
- NOMINAL
- NPER
- NPV
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- STOCK
- STOCKH
- SYD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
-
- ABS
- CEILING
- COMBIN
- EVEN
- EXP
- FACT
- FACTDOUBLE
- FLOOR
- GCD
- INT
- LCM
- LN
- LOG
- LOG10
- MDETERM
- MINVERSE
- MMULT
- MOD
- MROUND
- MULTINOMIAL
- MUNIT
- ODD
- PI
- POLYNOMIAL
- POWER
- PRODUCT
- QUOTIENT
- RAND
- RANDARRAY
- RANDBETWEEN
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SEQUENCE
- SERIESSUM
- SIGN
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TRUNC
-
- ADDRESS
- AREAS
- CHOOSE
- CHOOSECOLS
- CHOOSEROWS
- COLUMN
- COLUMNS
- DROP
- EXPAND
- FILTER
- FORMULATEXT
- GETPIVOTDATA
- HLOOKUP
- HSTACK
- HYPERLINK
- INDEX
- INDIRECT
- INTERSECT.RANGES
- LOOKUP
- MATCH
- OFFSET
- REFERENCE.NAME
- ROW
- ROWS
- SORT
- SORTBY
- TAKE
- TOCOL
- TOROW
- TRANSPOSE
- UNION.RANGES
- UNIQUE
- VLOOKUP
- VSTACK
- WRAPCOLS
- WRAPROWS
- XLOOKUP
- XMATCH
-
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MAXIFS
- MEDIAN
- MIN
- MINA
- MINIFS
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
- Copyright
LET
The LET function allows you to define named variables, assign the variables values/calculated results and reference them in an expression.
LET(name, value, name…, value…, calculation-or-name)
name: The name to give to the first variable to define.
value: The value assigned to the variable.
name…:Optionally include another variable to define.
value…: The value assigned to any other optional variables.
calculation-or-name: A name to give another variable to define or a calculation that uses names in the LET function. Must be the last argument.
Notes
At least one name/value pair must be defined, but LET supports up to 126 pairs.
LET allows you to define variable names that are represented as formula tokens. After they are defined, they can appear in type-ahead and be referenced elsewhere in the function.
Examples |
|---|
Suppose an expense charges a £10 daily rate and you want to calculate the cost of that expense over a week. In the example below, Rate is the variable name, 10 is the value that’s assigned to that variable and Rate*7 calculates the weekly cost. =LET(Rate,10,Rate*7) returns 70. To separately calculate and compare the cost of that expense over a typical week, month and year, you can assign a variable to each period of time. In the examples below, the variable x and a value of 7 represent a week, the variable y and a value of 30 represent a month, and the variable z and a value of 365 represent a year. =LET(Rate, 10, x, 7, y, 30, z, 365, Rate*x) returns 70, the cost for the week. =LET(Rate, 10, x, 7, y, 30, z, 365, Rate*y) returns 300, the cost for the month. =LET(Rate, 10, x, 7, y, 30, z, 365, Rate*z) returns 3650, the cost for the year. To calculate the cost of that daily expense over a specific time frame — for example 2 years, 2 months and 2 weeks — the expression would read: =LET(Rate, 10, x, 7, y, 30, z, 365, Rate*2*x + Rate*2*y + Rate*2*z). |