CUETMOCK
  • Pricing
  • Mentors
Log inStart freeStart free mocks→

First test, then trust

Try a free CUET mock test.

Join 5,00,000+ students who rehearsed exam day on the exact NTA screen before sitting CUET. On the web and on Android.

Start free mocks →Get the Android app
CUETMOCK

India's #1 CUET Mock Test Platform. Original NCERT-based questions on the exact NTA exam screen — trusted by 5,00,000+ students since CUET 2022.

Get it onGoogle PlayScan to download the CUETMOCK app

Mock tests

  • CUET mock test series
  • Browse all papers
  • Commerce mocks
  • Humanities (Arts) mocks
  • Science mocks
  • Languages & GAT mocks
  • Free practice questions
  • Pricing

Resources

  • CUET exam guide
  • CUET syllabus
  • Universities accepting CUET
  • Expert blogs
  • News & notifications
  • Webinars & counselling
  • CUET score calculator
  • How we estimate your rank
  • FAQs

Company

  • About us
  • Our leadership & team
  • Our toppers
  • Mentors
  • For schools
  • Contact us
  • Terms
  • Privacy
  • Refund policy

Talk to us

+91 7696 6630 56info@cuetmock.comWhatsApp us

Our other platforms

  • JEE Mock — For IIT-JEE aspirants
  • NEET Mock — For NEET aspirants

Newsletter

Exam updates, study material and offers — no spam.

© 2026 NYC Ventures Pvt. Ltd.

701-702, Royal Business Park, Zirakpur, Punjab - 140603

  • Terms of use
  • Privacy policy
  • Refund policy
  • Contact us

iCUETMOCK is an independent preparation platform, not affiliated with the National Testing Agency (NTA). Always check exam details on the official NTA website.

  • Home
  • Mock tests
  • CUET guide
  • Pricing
  • Log in
Home/Practice questions/Accountancy Part C
Accountancy Part CSpreadsheet

What would be the syntax for "IF" Function to get a result of Pass or…

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 IF function checks a condition and returns one value when the condition is true and another when it is false. Its format is IF(logical_test, value_if_true, value_if_false), and the logical test uses an operator such as >=, < or =.

Here the student passes at 40% and above, so the test is A1>=40%. When the test is true the result must be "PASS", so "PASS" goes in the second place and "FAIL" in the third.

Why the other options are incorrect

  • Option (2) =IF(A1<40,"PASS", "FAIL") — Incorrect. It returns "PASS" when the marks are below 40, which reverses the result.

  • Option (3) =IF(A1>=40, "FAIL","PASS") — Incorrect. The test is right in direction, but the two values are swapped, so a student with 40% or more is shown as "FAIL".

  • Option (4) =IF(A1=40,"PASS", "FAIL") — Incorrect. The operator = checks only one value, so a student with 75% would be shown as "FAIL".

NCERT (2026-27 edition):
IF Function

Extract from the NCERT textbook

Advertisement

Practise more on Spreadsheet

Chapter-wise mocks on the real NTA exam screen, with solutions and your rank. Your first mocks are free.

Start free mocks →

Advertisement

Next questions

  1. Besides Rasamanjari, what were the other popular themes among Basohli painters in the seventeenth century?Fine Arts · The Pahari Schools of Painting
  2. 'पेड़ के नीचे गाय बैठी है।' वाक्य में संबंधबोधक अव्यय है -Hindi · अव्यय (क्रिया-विशेषण, संबंधबोधक, समुच्चयबोधक, विस्मयादिबोधक)
  3. Why does the author feel that the rooms and verandahs have become deserted? A. No facilities for arranging meetings are availableB. The roo…English · Comprehension - (Narrative / Factual)
  4. Speed of a man is 50 km/hr. If he stops for a few minutes in an hour, then its average speed becomes 45 km/hr. Find the total time of stopp…General Aptitude Test · Numerical Ability
  5. Rahul alone can complete a work in 10 days and Sonu alone can complete the same work in 15 days. If they work together for 4 days then days…General Aptitude Test · Numerical Ability
  6. On differentiating e^x^2 with respect to x, we get:Maths. Section A · Continuity and Differentiability (Section A)
  7. The range of the function f(x) = cot^-1≤ft(x^2 - 2x + 2) , x real, isMaths. Section B1 · Inverse Trigonometric Functions
  8. Match List-I with List-II. List – I Methods of flotation of new issue List - II Advantage (A) Public issue (I) Entrepreneurs do not wish to…Entrepreneurship · Resource Mobilisation
  9. If ‘+’ means ‘÷’ , ‘×’ means ‘+’ , ‘–’ means ‘×’ , and ‘÷’ means ‘–’ , then which of the following equation is correct?General Aptitude Test · Verbal Reasoning
  10. When photons travel through crossed electric and magnetic field, perpendicular to both the fields then they are?Physics · Electromagnetic Waves