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
- 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
- MEDIAN
- MIN
- MINA
- 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
Copy or move formulas and their computed values
You can copy or move cells that contain formulas, or cells that are referenced by formulas, from one location to another.
When you copy and paste or drag a cell referenced by a formula to a new location, the cell reference in the formula is automatically updated. For example, if a reference to A1 appears in a formula and you move A1 to D5, the cell reference in the formula becomes D5.
When you copy or move a cell containing a formula, you may need to change absolute and relative cell references.
Copy and move cells containing a formula
To move cell values within a table, to another table, or to a page or canvas, select a cell or several adjacent cells, then drag the selection until any destination cells are selected.
Values in the destination cells are replaced.
Values in the original location are removed.
To copy cells within a table to another table, or to the page or canvas, hold down the Option key while you drag selected cells.
Values in the destination cells are replaced.
Values in the original location are retained.
For specific instructions on how to accomplish tasks in the app you're using, see the help that accompanies the app. In the macOS apps, look under the Help menu. In the iOS or iPadOS apps, tap the More menu (three dots in the top-right corner), then tap Numbers Help. (If you don’t see Numbers Help, swipe up from the bottom of the controls). In the iCloud apps, click the Question Mark button in the top-right corner.