In Excel, what does the 'IF' function do?
A. Sums cells based on a condition
B. Counts cells based on a condition
C. Tests a condition and returns one value if true, another if false
D. Looks up a value in a table
Answer: Option C
Solution (By JKSSB Mock Tests)
The IF function evaluates a logical test and returns one value for true and another for false. COUNTIF, SUMIF are conditional counting/summing, VLOOKUP is lookup.
No comments yet. Be the first to start the discussion!