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 favorite drink is Grape Soda" | My favorite drink is Grape Soda |
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 “Grape Soda.”
Formula | Result |
|---|---|
="My favorite drink is ""Grape Soda""" | My favorite drink is "Grape Soda" |
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 favorite drink is.”
Formula | Result |
|---|---|
=A1 & " Lemonade" | My favorite drink is Lemonade |
In the example below, additional double quotation marks are used as escape characters around the reference to cell A1 (A1 contains “Green Tea”) to return quotation marks in the result.
Formula | Result |
|---|---|
="My favorite drink is """&A1&"""" | My favorite drink is "Green Tea" |
You can also use CHAR with code-number 34 to indicate where you want to return a double quotation.