Question

In cell i5, insert a formula using the AND function that returns true if the number of days overdue (cell g5) is greater than 21 and if the pledge amount (cell d5) is greater than 800.

What is the correct formula for the given condition?
a. IF(AND(g5 > 21, d5 > 800), TRUE, FALSE)
b. OR(g5 > 21, d5 > 800)
c. IF(OR(g5 > 21, d5 > 800), TRUE, FALSE)
d. AND(g5 > 21, d5 > 800)

Answer 1

The correct formula for checking if the days overdue is greater than 21 and the pledge amount is greater than 800 is by using the AND function option a or d: EITHER 'IF(AND(G5 > 21, D5 > 800), TRUE, FALSE)' or simply 'AND(G5 > 21, D5 > 800)'.

The correct formula to use in this scenario, to determine if both conditions are met, is the AND function. The AND function will return TRUE only if all the conditions mentioned are true. Therefore, the answer is option a. This formula uses the AND function to check whether the number of days overdue in cell G5 is greater than 21, and if the pledge amount in cell D5 is greater than 800:

IF(AND(G5 > 21, D5 > 800), TRUE, FALSE)

The use of the IF function is unnecessary since the AND function already returns a boolean value (TRUE or FALSE); thus, option d, which is the simplified version without the IF, is also correct:

AND(G5 > 21, D5 > 800)