What would be the syntax for "IF" Function to get a result of Pass or Fail if Passing criteria is 40% and above. Further percentage of marks is available in Cell A1?
Answer & explanation
Correct answer: option 1
The correct answer is option 1- =IF(A1>=40%, "PASS", "FAIL").
The correct syntax is =IF(A1>=40%, "PASS", "FAIL").
-
You want to return "PASS" if the percentage in cell A1 is 40% or more, and "FAIL" otherwise.
-
A1 >= 40% checks if the value in A1 is greater than or equal to 40%.
-
The IF function then returns "PASS" if this condition is true, otherwise it returns "FAIL".