DocMCQs Educational Banner

What is the function of the IF function in Excel?

Question: What is the function of the IF function in Excel?
  • A. To perform a logical test and return a value based on the result βœ“
  • B. To add up a range of cells
  • C. To find the average of a range of cells
  • D. To count the number of cells in a range
Correct Answer: A. To perform a logical test and return a value based on the result
Explanation: The IF function checks a condition and returns one value if TRUE and another if FALSE.

Leave a Comment

Your email address will not be published. Required fields are marked *

Join Our WhatsApp Channel ×
Scroll to Top