RRB Technician Grade I 19 Dec 2024 Shift 2 Paper

Concept:The IF function is a logical function in MS-Excel that checks a condition and returns one value when the condition is true and another when it is false.Explanation:The IF function tests a given condition, which is called the logical test.It returns the value_if_true when the condition is satisfied.It returns the value_if_false when the condition is not satisfied.The syntax of the IF function is $=IF(logical\_test, value\_if\_true, value\_if\_false)$.Here, logical_test is the condition that evaluates to either TRUE or FALSE.value_if_true is returned when the logical test is TRUE.value_if_false is returned when the logical test is FALSE.For example, $=IF(B2 \ge 50, \text{"Pass"}, \text{"Fail"})$ checks if the score in cell B2 is greater than or equal to 50.If this condition is true, the function returns "Pass".If this condition is false, the function returns "Fail".Thus, the IF function is used for decision-making and conditional calculations in Excel.Answer:C. It checks a condition and returns one value if true and another if false.