IF Function

Which is the correct way to write this function:
IF B4 is greater than 200, show "High", otherwise, show "Low"

• IF(B4>200,"High","Low")
• =IF(B4<200,"High","Low")
• =IF(B4>200,"High","Low")
• =IF(B4>200"High","")

Which is the correct way to write this function:

IF C3 is equal to 70, show "Pass", otherwise, show "Fail"

• =IF C3=70,"Pass","Fail"

• =IF(C3=70,"Fail","Pass")

• =IF(C3=70,Fail,Pass)

• =IF(C3=70,"Pass","Fail")

Which is the correct way to write this function:
IF B7 is greater or equal to 50, show "Bonus", otherwise, show "No Bonus".

• =IF(B7>=50,"Bonus","No Bonus")
• IF(B7>=50,"Bonus","No Bonus")
• =IF(B7>50,"Bonus","No Bonus")
• =IF(B7=50,"Bonus","No Bonus")

Which is the correct way to write this function:

IF C4 is less than 75, multiply C4 by 10, otherwise, show 0.

• =IF(C4<75,"Multiply 10","0")

• =IF(C4<75,C4x10,0)

• =IF(C4<75,C4*10,0)

• =IF(C4>75,C4*10,0)

Which of these symbols means "greater than"?

• >
• <
• =
• $

In this IF function example:  =IF(G8>40,"Yes","No")
What would show in the cell after you hit enter if the value in G8 was 62?

• Yes
• No
• Nothing would show

In the IF function example:
=IF(A23>=100,"Prize","No Prize")
What would show in the cell after you hit enter if the value in A23 is 89?

• Prize
• No Prize
• Nothing would show in the cell

Which of these symbols mean "less than"?

• <
• >
• =
• +

Which is the correct way to write this function:
IF B8 is greater than C8, show "Win", otherwise, show "Lose"

• =IF(B8=C8,"Win","Lose")
• =IF(B8>C8,Win,Lose)
• =IF(B8>C8,"Win","Lose")
• =IF("B8>C8","Win","Lose")

In this IF function example:

=IF(F2<30,100-F2,0)

What would show in the cell after you hit enter if the value in F2 is 29?

• 100

• 52

• 30

• 71