📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!


    Question

    In MS Excel, the 'IF' function is used

    to:
    A Look up a value in a table. Correct Answer Incorrect Answer
    B Perform a logical test and return one value if true and another if false. Correct Answer Incorrect Answer
    C Calculate the sum of a range of cells. Correct Answer Incorrect Answer
    D Find the average of a range of cells. Correct Answer Incorrect Answer

    Solution

    The IF function is a logical function that returns one value if a specified condition evaluates to TRUE, and another value if it evaluates to FALSE. Its syntax is =IF(logical_test, value_if_true, [value_if_false]). It is fundamental for conditional calculations.

    Practice Next
    ask-question