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
ADDRESS
The ADDRESS function constructs a cell address string from separate row, column and table identifiers.
ADDRESS(row, column, addr-type, addr-style, table)
row: A number value representing the row number of the address. row must be in the range 1 to 65,535.
column: A number value representing the column number of the address. column must be in the range 1 to 255.
addr-type: An optional modal value specifying whether the row and column numbers are preserved when pasting or filling cells.
both preserved (1 or omitted): Both row and column references are preserved.
row preserved (2): Row references are preserved; column references are not preserved.
column preserved (3): Column references are preserved; row references are not preserved.
neither preserved (4): Row and column references are not preserved.
addr-style: An optional modal value specifying the address style.
A1 (TRUE, 1 or omitted): The address format should use letters for columns and numbers for rows.
R1C1 (FALSE): The address should use the format R1C1, where R1 is the row number of a cell and C1 is the column number.
table: An optional value specifying the name of the table. table is a string value. If the table is on another sheet, you must also include the name of the sheet. If omitted, table is assumed to be the current table on the current sheet (that is, the table where the ADDRESS function resides).
Examples |
|---|
=ADDRESS(3, 5) creates the address $E$3. =ADDRESS(3, 5, 2) creates the address E$3. =ADDRESS(3, 5, 3) creates the address $E3. =ADDRESS(3, 5, 4) creates the address E3. =ADDRESS(3, 3,,,“Sheet 2::Table 1”) creates the address Sheet 2::Table 1::$C$3. |