easy5 pts · first answer countsexcellogical-functions

Pass or fail with IF

Marks are in B2 and the pass mark is 40. Which formula shows "Pass" for 40 or more and "Fail" otherwise?

A.=IF(B2>40,"Pass","Fail")B.=IF(B2>=40,Pass,Fail)C.=IF(B2>=40,"Pass","Fail")D.=IF("Pass",B2>=40,"Fail")

Discussion 0

Join free to post in the discussion.