Computer question from Jr. Assistant exam, 2026 by JKSSB
A company keeps sales data in column B and wants to categorise sales into three levels: "High" if sales ≥ 1000 "Medium" if sales ≥ 500 but < 1000 "Low" if sales < 500 A student writes the formula in cell C2 as: =IF(B2>=1000,"High",IF(B2>=500,"Medium","Low")) Which of the following statements is/are correct?
Last updated Jun 24, 2026
Correct Answer:
Option D —
The formula will work correctly for all numeric values in B2.
Logic of the Formula
The student is using a Nested IF function. This is the standard way to evaluate multiple conditions in Excel by placing one "IF" inside another.
Step 1: The computer checks the first condition. If the value is greater than or equal to one thousand, it outputs "High" and finishes.
Step 2: If the first condition is false (meaning the number is definitely less than one thousand), it moves to the second "IF."
Step 3: It then checks if the value is greater than or equal to five hundred. If true, it outputs "Medium."
Step 4: If both conditions are false (meaning the number is less than five hundred), it outputs "Low."
Analysis of the Options
A) The formula will always give an error: This is incorrect because the structure of the formula is perfect. It follows the standard rules of Excel logic.
B) The formula will give an error if B2 is blank: In Excel, a blank cell is mathematically treated as zero. Since zero is less than five hundred, the formula would simply return "Low."
C) The formula will give an error for non-numeric values: This is a tricky part of Excel behavior. If B2 contains text (like the word "Sales"), Excel treats text as being "greater" than any number. Therefore, it would return "High" rather than an error code.
D) Correctness for Numeric Values: As long as the data entered is a number, the logic perfectly categorizes the three levels as intended.
Answer verified by Quintessence Classes faculty — Karan Nagar, Srinagar.
