IF Statements

What is the output if cell A1 contains the number 8.

=IF(A1<10, "Low", "High")

• High

• Low

What is the output if cell B2 contains the number 15.

=IF(B2>20, "Above", "Below")

• Above

• Below

What is the output if cell C3 contains the number 5.

=IF(C3=5, "Equal", "Not Equal")

• Equal

• Not Equal

What is the output if cell D4 contains the number 12.

=IF(D4<=10, "Small", "Large")

• Small

• Large

What is the output if cell E5 contains the number 3.

=IF(E5>=3, "Match", "No Match")

• Match

• No Match

What is the output if cell G7 contains the number 7.

=IF(G7<=5, "Under", "Over")

• Under

• Over

What is the output if cell F6 contains the number 10.

=IF(F6=10, "Yes", "No")

• Yes

• No

What is the output if cell H8 contains the number 20.

=IF(H8>15, "Greater", "Lesser")

• Greater

• Lesser

What is the output if cell J9 contains the number 4.

=IF(J9<5, "Below", "Above")

• Below

• Above

What is the output if cell K2 contains the number 9.

=IF(K2>=10, "High", "Low")

• High

• Low