Nathan Is in Charge of Collections, and Is Putting Together

Multiple Choice

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)