Get Started
Start Free Mocks
CUETMOCK

Ace Your

CUET Preparation Today

Start Free Mocks
Home Questions HD88VQYMRU
Target Exam

CUET

Subject

-- Accountancy Part C

Chapter

Spreadsheet

Question:

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?

Options:

=IF(A1>=40%, "PASS", "FAIL")

=IF(A1<40,"PASS", "FAIL")

=IF(A1>=40, "FAIL","PASS")

=IF(A1=40,"PASS", "FAIL")

Correct Answer:

=IF(A1>=40%, "PASS", "FAIL")

Explanation:

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".

CUET Questions