JKSSB Written 2026
Answer & Explanation
Click "Check Answer" to reveal
Correct Answer:
Option D —
The formula will work correctly for all numeric values in B2.
Logic of the FormulaThe 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.