Multiple choice technology

What function offers you the possibility to view different results depending on the entered condition?

  1. =If()

  2. =Sum()

  3. =SumIf()

  4. =TrueFalse()
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The IF function evaluates a condition and returns one value if TRUE and another if FALSE, allowing different results based on the entered condition. The syntax is =IF(condition, value_if_true, value_if_false). SUM simply adds values, SUMIF adds values meeting a condition, and TrueFalse is not a valid Excel function.

Keep practicing — related questions