Formulas and Functions Help
- Welcome
- Intro to formulas and functions
-
- 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
-
- 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
Tips for using double quotations in formulas
You can use double quotations in a formula to indicate a string. You can also escape the double quotations, which causes Numbers, Pages and Keynote to return quotation marks as part of a text string, instead of treating it as the start or end of a string.
In the example below, the quotation marks indicate the start and end of the string, with no quotation marks included in the result.
Formula | Result |
|---|---|
="My favourite drink is Ginger Beer" | My favourite drink is Ginger Beer |
If you want to include quotation marks in the result, you can add additional double quotations as escape characters.
In the example below, the first and last quotations indicate the start and end of the string. The two pairs of double quotations indicate that a double quotation should be returned as text on each side of the term “Ginger Beer”.
Formula | Result |
|---|---|
="My favourite drink is ""Ginger Beer""" | My favourite drink is "Ginger Beer" |
Double quotations can also be used in the same formula as cell references to indicate a string.
For the example below, let A1 contain “My favourite drink is ”.
Formula | Result |
|---|---|
=A1 & "Lemonade" | My favourite drink is Lemonade |
In the example below, additional double quotation marks are used as escape characters around the reference to cell A1 (A1 contains “Earl Grey Tea”) to return quotation marks in the result.
Formula | Result |
|---|---|
="My favourite drink is """&A1&"""" | My favourite drink is "Earl Grey Tea" |
You can also use CHAR with code-number 34 to indicate where you want to return a double quotation.