Formulas Flashcards
SUM
=SUM(A1:A2)
Product
=PRODUCT(A1,A2)
SQUARE ROOT
SQRT(A1)
E^2
=EXP(2)
LN
LN(A1)
SUMPRODUCT
=SUMPRODUCT(A1:A2,B1:B2)
AND
=AND(logical 1, ~logical 2~)
OR
=OR(Logical 1, ~logical 2~)
IF
=IF(logical, “true”, “false”)
COUNT
=COUNT(A1:A2)
COUNTA
=COUNTA(A1:A2)
MINIMUM
=MIN(A1:A2)
MAXIMUM
=MAX(A1:A2)
SMALLEST
=SMALL(A1:A2, K)
LARGEST
=LARGE(A1:A2, K)
RANK EQUAL
=RANK.EQ(NUMBER, A1:A2, 0/1)
0 = DESCENDING
1 = ASCENDING
RANK AVERAGE
=RANK.AVG(NUMBER, A1:A2, 0/1)
MEAN
=AVERAGE(A1:A2)
MEDIAN
=MEDIAN(A1:A2)
VARIANCE
=VAR.S(A1:A2)
STANDARD DEVIATION
=STDEV.S(A1:A2)
COVARIANCE
=COVARIANCE.S(A1:A2, B1:B2)
CORRELATION
=CORREL(A1:A2, B1:B2)
COUNT IF
=COUNTIF(A1:A2, CRITERIA)
MANY COUNT IFS
=COUNTIFS(A1:A2, CRITERIA 1, B1:B2, CRITERIA 2)
SUM IF
=SUMIF(RANGE A1:A2, CRITERIA, NUMBERS TO ADD UP)
MANY SUM IFS
=SUMIFS(NUMBERS TO ADD UP, Range A1:A2, Criteria 1, Range B1:B2, Criteria 2)
AVERAGE IF
=AVERAGEIF(RANGE A1:A2, CRITERIA, NUMBERS TO AVG UP)
MANY AVERAGE IFS
=AVERAGEIFS(NUMBERS TO AVG UP, Range A1:A2, Criteria 1, Range B1:B2, Criteria 2)
COUNT BLANK CELLS
=COUNTBLANK(A1:A2)
UNIQUE
=UNIQUE(A1:A2)
PERCENTILE
=PERCENTILE(A1:A2, K) (K=0.?)
ROUND
=ROUND(A1, NUM OF DIGITS AFTER .)
NOT
NOT(ARGUMENT)
IF ERROR
=IFERROR(VALUE, “0”)
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))
PRESENT VALUE
=PV(rate, # of payments, payment, ~FV, 0 (end) or 1 (start))
FUTURE VALUE
=FV(Rate, # of payments, payment, ~PV, 0 (end) or 1 (start))
PAYMENTS
=PMT(rate, # of payments, PV, ~FV, 0 (end) or 1 (start))
