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.
-One of the daily reports that is delivered to management every day lists any customer who has a balance due of $100,000 or more. If the customer has a high balance, the formula should return due date. Otherwise, the cell is left blank. Assuming that the balance due is in column D in the spreadsheet above, what would the formula look like?

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.
-One of the daily reports that is delivered to management every day lists any customer who has a balance due of $100,000 or more. If the customer has a high balance, the formula should return due date. Otherwise, the cell is left blank. Assuming that the balance due is in column D in the spreadsheet above, what would the formula look like?
A) =IF(D5=100000,B5, " ") 
B) =IF(D5<99999,B5," ") 
C) =IF(D5>=100000,B5," ") 
D) =IF(D5," ",B5)

Quizplus · Accepted Answer

The formula needs to check if the balance due in column D is greater than or equal to $100,000. If it is, then it should return the due date in column B. The correct formula for this is =IF(D5>=100000,B5," "). Option A checks if the balance due is exactly $100,000, which may exclude some customers with higher balances. Option B checks if the balance due is less than $99,999, which may exclude customers with exactly $100,000 due. Option D is not checking the balance due at all, and simply returns a blank cell for all customers.

Nathan Is in Charge of Collections, and Is Putting Together