top of page
Excel in Excel
Formulas
=IF(logical_test, [value_if_true], [value_if_false])
-
See 'If Only...'
​
=INDEX(array, row_num, [column_num], MATCH(lookup_value, lookup_array, [match_type])
-
See 'INDEX-MATCH'
=CONCATENATE(text1, text2...)
​
=COUNT(value1, [value2]...)
​​
​
=COUNTIF(range, criteria)
-
See 'COUNTIF'
​
=COUNTIFS(criteria_range1, criteria1, criteria_range2, criteria2...)
-
See 'COUNTIFS'
​​
C
A
D
E
S
I
T
B
F
G
H
K
J
L
M
N
P
O
=RANDBETWEEN(bottom, top)
​
=RIGHT(text, [num_chars])
R
Q
=SUMIF(range, criteria, [sum_range])
-
See 'SUMIF'
​
=SUMIFS(sum_range, criteria_range1, criteria1...)
-
See 'SUMIFS'
​​
U
V
W
X
Y
Z
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=LEFT(text, [num_chars])
bottom of page