Question

Which of the following describes the result of AND function in Excel

• A. It returns TRUE if any of its arguments are true
• B. It returns a numerical value indicating the count of TRUE argument
• C. It returns TRUE only if all the conditions are true
• D. It always returns the value of the last logical argument evaluated

Answer 1

Answer:

C. It returns TRUE only if all the conditions are true

It returns TRUE only if all the conditions are true AND Function: In Excel, the AND function evaluates multiple conditions and returns TRUE only if every single condition/argument is met (true). If even one condition is false, it returns FALSE. Contrast with OR: The statement "It returns TRUE if any of its arguments are true" describes the OR function instead.