Nathan is in charge of collections, and is putting together a list of customers to call. Please refer to the figure above as you answer the questions below.
-Instead of "Call," Nathan has decided to list the due date for those customers who have a FALSE value in column C. Customers with a TRUE value in column C should still generate a "Don't Call" value. His formula now looks like ____.
A) =IF(C5,"Don't Call",B5)
B) =IF(C5,B5,"Don't Call")
C) =AND(C5,B5,"Don't Call")
D) =AND(C5,"Don't Call",B5)

Question

Nathan is in charge of collections, and is putting together a list of customers to call. Please refer to the figure above as you answer the questions below.
-Instead of "Call," Nathan has decided to list the due date for those customers who have a FALSE value in column C. Customers with a TRUE value in column C should still generate a "Don't Call" value. His formula now looks like ____.
A) =IF(C5,"Don't Call",B5) 
B) =IF(C5,B5,"Don't Call") 
C) =AND(C5,B5,"Don't Call") 
D) =AND(C5,"Don't Call",B5)

Quizplus · Accepted Answer

The correct formula is =IF(C5,"Don't Call",B5) because it checks if the value in C5 is TRUE, then returns "Don't Call". If FALSE, it returns the due date listed in B5.

Nathan Is in Charge of Collections, and Is Putting Together