7e2387 |
ROW |
=ROW(A1) |
value |
|
31576b |
ROW |
=ROW(A5) |
value |
|
b3ae3b |
ROW |
=ROW(C10) |
value |
|
dacc46 |
ROW |
=ROW(B7:D9) |
value |
|
4f7ad0 |
ROW |
=ROW() |
value |
|
9ffb02 |
COLUMN |
=COLUMN(A1) |
value |
|
f264fd |
COLUMN |
=COLUMN(C1) |
value |
|
e16b26 |
COLUMN |
=COLUMN(Z1) |
value |
|
d3d1ea |
COLUMN |
=COLUMN(D2:F4) |
value |
|
e9a74a |
COLUMN |
=COLUMN() |
value |
|
4575b0 |
ROWS |
=ROWS(A1:A3) |
value |
1 |
e34323 |
ROWS |
=ROWS(A1) |
value |
1 |
39b86b |
ROWS |
=ROWS(B2:D10) |
value |
1 |
0feed3 |
ROWS |
=ROWS({1;2;3;4}) |
value |
2 |
3cf205 |
ROWS |
=ROWS({1,2;3,4;5,6}) |
value |
2 |
e14311 |
COLUMNS |
=COLUMNS(A1:C1) |
value |
1 |
bc933c |
COLUMNS |
=COLUMNS(A1) |
value |
1 |
1c6f2b |
COLUMNS |
=COLUMNS(B2:D10) |
value |
1 |
82d96a |
COLUMNS |
=COLUMNS({1,2,3,4,5}) |
value |
2 |
11ac7b |
COLUMNS |
=COLUMNS({1,2;3,4;5,6}) |
value |
2 |
b16b29 |
ADDRESS |
=ADDRESS(1,1) |
value |
1 |
354491 |
ADDRESS |
=ADDRESS(1,1,4) |
value |
1 |
5c279f |
ADDRESS |
=ADDRESS(2,3,2) |
value |
1 |
b31c18 |
ADDRESS |
=ADDRESS(2,3,3) |
value |
1 |
fda9c1 |
ADDRESS |
=ADDRESS(5,26,4) |
value |
1 |
cbc5b1 |
ADDRESS |
=ADDRESS(1,27,4) |
value |
1 |
b3d331 |
ADDRESS |
=ADDRESS(1,1,1,TRUE,"Sheet2") |
value |
|
43b667 |
OFFSET |
=OFFSET(A1,1,0)+0 |
value |
3 |
2987c1 |
OFFSET |
=OFFSET(A1,0,2)+0 |
value |
3 |
fecead |
OFFSET |
=OFFSET(A1,0,0)+0 |
value |
3 |
67be54 |
OFFSET |
=SUM(OFFSET(A1,0,0,2,2)) |
value |
2 |
500e03 |
OFFSET |
=SUM(OFFSET(A1,1,0,3,1)) |
value |
2 |
3aa075 |
OFFSET |
=OFFSET(A3,-2,0)+0 |
value |
3 |
2060ee |
INDIRECT |
=INDIRECT("A1") |
value |
1 |
653ff9 |
INDIRECT |
=INDIRECT("B3") |
value |
1 |
f166ec |
INDIRECT |
=SUM(INDIRECT("A1:A3")) |
value |
2 |
3e0cc4 |
INDIRECT |
=INDIRECT("A" & 5) |
value |
1 |
2ee44a |
INDIRECT |
=INDIRECT("not a ref") |
value |
1 |
4ccf67 |
INDIRECT |
=INDIRECT("R1C1", FALSE) |
value |
3 |
533001 |
LOOKUP |
=LOOKUP(2, A1:A3, B1:B3) |
value |
1 |
2eed78 |
LOOKUP |
=LOOKUP(4, A1:A3, B1:B3) |
value |
1 |
f2b34f |
LOOKUP |
=LOOKUP(20, A1:A3) |
value |
1 |
2086c6 |
LOOKUP |
=LOOKUP(5, A1:A3, B1:B3) |
value |
1 |
8bd5ce |
LOOKUP |
=LOOKUP(99, A1:A3, B1:B3) |
value |
1 |
2ba786 |
LOOKUP |
=LOOKUP(2, {1,2,3;"a","b","c"}) |
value |
|
8f8042 |
FORMULATEXT |
=FORMULATEXT(A1) |
value |
|
38c271 |
FORMULATEXT |
=FORMULATEXT(A1) |
value |
|
6a3757 |
FORMULATEXT |
=FORMULATEXT(A1) |
value |
|
4445b3 |
FORMULATEXT |
=FORMULATEXT(B1) |
value |
|
c7666b |
GETPIVOTDATA |
=GETPIVOTDATA("Sales", A1) |
value |
|
6554cd |
GETPIVOTDATA |
=GETPIVOTDATA("Total", A1, "Region", "West") |
value |
|
6d4b89 |
SHEET |
=SHEET() |
value |
|
14f3b2 |
SHEET |
=SHEET(A1) |
value |
|
ac9ef7 |
SHEET |
=SHEET("Sheet1") |
value |
|
f520f6 |
SHEET |
=SHEET("NoSuchSheet") |
value |
|