Formulas Flashcards
(39 cards)
1
Q
SUM
A
=SUM(A1:A2)
2
Q
Product
A
=PRODUCT(A1,A2)
3
Q
SQUARE ROOT
A
SQRT(A1)
4
Q
E^2
A
=EXP(2)
5
Q
LN
A
LN(A1)
6
Q
SUMPRODUCT
A
=SUMPRODUCT(A1:A2,B1:B2)
7
Q
AND
A
=AND(logical 1, ~logical 2~)
8
Q
OR
A
=OR(Logical 1, ~logical 2~)
9
Q
IF
A
=IF(logical, “true”, “false”)
10
Q
COUNT
A
=COUNT(A1:A2)
11
Q
COUNTA
A
=COUNTA(A1:A2)
12
Q
MINIMUM
A
=MIN(A1:A2)
13
Q
MAXIMUM
A
=MAX(A1:A2)
14
Q
SMALLEST
A
=SMALL(A1:A2, K)
15
Q
LARGEST
A
=LARGE(A1:A2, K)
16
Q
RANK EQUAL
A
=RANK.EQ(NUMBER, A1:A2, 0/1)
0 = DESCENDING
1 = ASCENDING
17
Q
RANK AVERAGE
A
=RANK.AVG(NUMBER, A1:A2, 0/1)
18
Q
MEAN
A
=AVERAGE(A1:A2)
19
Q
MEDIAN
A
=MEDIAN(A1:A2)
20
Q
VARIANCE
A
=VAR.S(A1:A2)
21
Q
STANDARD DEVIATION
A
=STDEV.S(A1:A2)
22
Q
COVARIANCE
A
=COVARIANCE.S(A1:A2, B1:B2)
23
Q
CORRELATION
A
=CORREL(A1:A2, B1:B2)
24
Q
COUNT IF
A
=COUNTIF(A1:A2, CRITERIA)
25
MANY COUNT IFS
=COUNTIFS(A1:A2, CRITERIA 1, B1:B2, CRITERIA 2)
26
SUM IF
=SUMIF(RANGE A1:A2, CRITERIA, NUMBERS TO ADD UP)
27
MANY SUM IFS
=SUMIFS(NUMBERS TO ADD UP, Range A1:A2, Criteria 1, Range B1:B2, Criteria 2)
28
AVERAGE IF
=AVERAGEIF(RANGE A1:A2, CRITERIA, NUMBERS TO AVG UP)
29
MANY AVERAGE IFS
=AVERAGEIFS(NUMBERS TO AVG UP, Range A1:A2, Criteria 1, Range B1:B2, Criteria 2)
30
COUNT BLANK CELLS
=COUNTBLANK(A1:A2)
31
UNIQUE
=UNIQUE(A1:A2)
32
PERCENTILE
=PERCENTILE(A1:A2, K) (K=0.?)
33
ROUND
=ROUND(A1, NUM OF DIGITS AFTER .)
34
NOT
NOT(ARGUMENT)
35
IF ERROR
=IFERROR(VALUE, "0")
36
LOOK UP VALUES
=XLOOKUP(LOOK UP VALUE, LOOK UP ARAY, RETURN ARAY, ~"MESSAGE" IF NOT FOUND, MATCH MODE (0 - exact, -1 smaller, 1 larger), SEARCH MODE (1 first to last, -1 last to first))
37
PRESENT VALUE
=PV(rate, # of payments, payment, ~FV, 0 (end) or 1 (start))
38
FUTURE VALUE
=FV(Rate, # of payments, payment, ~PV, 0 (end) or 1 (start))
39
PAYMENTS
=PMT(rate, # of payments, PV, ~FV, 0 (end) or 1 (start))
