FORMULAS & STATEMENTS

Question 1

IF STATEMENT

Answer 1

OUTPUT BASED ON SINGLE CRITERIA

Question 2

IF STATEMENT - FORMULA

Answer 2

=IF(CONDITION, IF TRUE, IF FALSE)

Question 3

IF(AND STATEMENT

Answer 3

OUTPUT IF MULTIPLE CRITERIA MET

Question 4

IF(AND - FORMULA

Answer 4

=IF(AND(CONDITION 1, CONDITION 2),IF TRUE, IF FALSE)

Question 5

IF(OR STATEMENT

Answer 5

OUTPUT IF 1 OF MULTIPLE CRITERIA IS MET

Question 6

IF(OR - FORMULA

Answer 6

=IF(OR(CONDITION 1, CONDITION 2), IF TRUE, IF FALSE)

Question 7

SUMIF STATEMENT

Answer 7

SUM CELL TOTALS BASED ON SINGLE CRITERIA

Question 8

SUMIF - FORMULA

Answer 8

=SUMIF(CRITERIA RANGE, CRITERIA, SUM RANGE)

Question 9

SUMIFS STATEMENT

Answer 9

SUMS CELLS BASED ON MULTIPLE CRITERIA

Question 10

SUMIFS - FORMULA

Answer 10

=SUMIFS(SUM RANGE,C1 RANGE, C1, C2 RANGE, C2)

Question 11

COUNTIF STATEMENT

Answer 11

COUNTS NUMBER OF CELLS MEETING SINGLE CRITERIA

Question 12

COUNTIF - FORMULA

Answer 12

=COUNTIF(CRITERIA RANGE, CRITERIA)

Question 13

COUNTIFS STATEMENT

Answer 13

COUNTS CELLS MEETING MULTIPLE CRITERIA

Question 14

COUNTIFS - FORMULA

Answer 14

=COUNTIFS(CR 1, C1, CR2, CR3, C3)

CR = CRITERIA RANGE

C= CRITERIA

Question 15

AVERAGEIF STATEMENT

Answer 15

AVERAGE CELLS BASED ON SINGLE CRITERIA

Question 16

AVERAGEIF - FORMULA

Answer 16

=AVERAGEIF(CR1, C1, AVERAGE RANGE)

Question 17

AVERAGEIFS STATEMENT

Answer 17

AVERAGE CELLS BASED ON MULTIPLE CRITERIA

Question 18

AVERAGEIFS - FORMULA

Answer 18

=AVERAGEIFS(AVERAGE RANGE, CR1, C1, CR2, C2)

CR = CRITERIA RANGE

C = CRITERIA

Question 19

USING QUOTATION MARKS AND ENPRESAND

Answer 19

USE QUOTATION MARK AND ENPRESAND WHEN THE CRITERIA RANGE IS AN ACTUAL RANGE INSTEAD OF SINGLE CELL

EX: SUM IF CELL VALUE IS > 25

=SUMIF(CRITERIA RANGE, “>“&25)