row-a1 |
ROW |
=ROW(A1) |
value |
|
row-a5 |
ROW |
=ROW(A5) |
value |
|
row-c10 |
ROW |
=ROW(C10) |
value |
|
row-range-first-row |
ROW |
=ROW(B7:D9) |
value |
|
row-no-arg |
ROW |
=ROW() |
value |
|
column-a1 |
COLUMN |
=COLUMN(A1) |
value |
|
column-c1 |
COLUMN |
=COLUMN(C1) |
value |
|
column-z1 |
COLUMN |
=COLUMN(Z1) |
value |
|
column-range-first-col |
COLUMN |
=COLUMN(D2:F4) |
value |
|
column-no-arg |
COLUMN |
=COLUMN() |
value |
|
rows-3-row-range |
ROWS |
=ROWS(A1:A3) |
value |
1 |
rows-single-cell |
ROWS |
=ROWS(A1) |
value |
1 |
rows-rectangular |
ROWS |
=ROWS(B2:D10) |
value |
1 |
rows-array-literal |
ROWS |
=ROWS({1;2;3;4}) |
value |
2 |
rows-2d-array-literal |
ROWS |
=ROWS({1,2;3,4;5,6}) |
value |
2 |
columns-3-col-range |
COLUMNS |
=COLUMNS(A1:C1) |
value |
1 |
columns-single-cell |
COLUMNS |
=COLUMNS(A1) |
value |
1 |
columns-rectangular |
COLUMNS |
=COLUMNS(B2:D10) |
value |
1 |
columns-array-literal |
COLUMNS |
=COLUMNS({1,2,3,4,5}) |
value |
2 |
columns-2d-array-literal |
COLUMNS |
=COLUMNS({1,2;3,4;5,6}) |
value |
2 |
address-absolute-a1 |
ADDRESS |
=ADDRESS(1,1) |
value |
1 |
address-relative |
ADDRESS |
=ADDRESS(1,1,4) |
value |
1 |
address-row-absolute |
ADDRESS |
=ADDRESS(2,3,2) |
value |
1 |
address-col-absolute |
ADDRESS |
=ADDRESS(2,3,3) |
value |
1 |
address-column-z |
ADDRESS |
=ADDRESS(5,26,4) |
value |
1 |
address-column-aa |
ADDRESS |
=ADDRESS(1,27,4) |
value |
1 |
address-with-sheet |
ADDRESS |
=ADDRESS(1,1,1,TRUE,"Sheet2") |
value |
|
offset-down-one |
OFFSET |
=OFFSET(A1,1,0)+0 |
value |
3 |
offset-right-one |
OFFSET |
=OFFSET(A1,0,2)+0 |
value |
3 |
offset-zero |
OFFSET |
=OFFSET(A1,0,0)+0 |
value |
3 |
offset-sum-height-width |
OFFSET |
=SUM(OFFSET(A1,0,0,2,2)) |
value |
2 |
offset-sum-shifted-range |
OFFSET |
=SUM(OFFSET(A1,1,0,3,1)) |
value |
2 |
offset-negative-rows |
OFFSET |
=OFFSET(A3,-2,0)+0 |
value |
3 |
indirect-a1-to-value |
INDIRECT |
=INDIRECT("A1") |
value |
1 |
indirect-text-cell |
INDIRECT |
=INDIRECT("B3") |
value |
1 |
indirect-sum-range |
INDIRECT |
=SUM(INDIRECT("A1:A3")) |
value |
2 |
indirect-concatenated |
INDIRECT |
=INDIRECT("A" & 5) |
value |
1 |
indirect-bad-ref |
INDIRECT |
=INDIRECT("not a ref") |
value |
1 |
indirect-r1c1-style |
INDIRECT |
=INDIRECT("R1C1", FALSE) |
value |
3 |
lookup-exact-sorted |
LOOKUP |
=LOOKUP(2, A1:A3, B1:B3) |
value |
1 |
lookup-approximate |
LOOKUP |
=LOOKUP(4, A1:A3, B1:B3) |
value |
1 |
lookup-vector-form-no-result |
LOOKUP |
=LOOKUP(20, A1:A3) |
value |
1 |
lookup-below-range |
LOOKUP |
=LOOKUP(5, A1:A3, B1:B3) |
value |
1 |
lookup-above-range-picks-last |
LOOKUP |
=LOOKUP(99, A1:A3, B1:B3) |
value |
1 |
lookup-array-form |
LOOKUP |
=LOOKUP(2, {1,2,3;"a","b","c"}) |
value |
|
formulatext-of-formula-cell |
FORMULATEXT |
=FORMULATEXT(A1) |
value |
|
formulatext-of-value-cell |
FORMULATEXT |
=FORMULATEXT(A1) |
value |
|
formulatext-of-empty |
FORMULATEXT |
=FORMULATEXT(A1) |
value |
|
formulatext-sum-formula |
FORMULATEXT |
=FORMULATEXT(B1) |
value |
|
getpivotdata-smoke |
GETPIVOTDATA |
=GETPIVOTDATA("Sales", A1) |
value |
|
getpivotdata-with-field |
GETPIVOTDATA |
=GETPIVOTDATA("Total", A1, "Region", "West") |
value |
|
sheet-no-arg |
SHEET |
=SHEET() |
value |
|
sheet-self-ref |
SHEET |
=SHEET(A1) |
value |
|
sheet-by-name-string |
SHEET |
=SHEET("Sheet1") |
value |
|
sheet-invalid-name |
SHEET |
=SHEET("NoSuchSheet") |
value |
|