Business rule: Customers that have a 90 day outstanding balance of more than $10

Question

Business rule:   Customers that have a 90 day outstanding balance of more than $10,000 are considered bad debts except if they have had total sales of more than a million dollars. An Excel spread sheet to identify if this customer is a bad debt has been created. Cell A5 should display the bad debt amount if this customer is a bad debt and nothing if they are OK. What would be the formula in A5?

A. IF(B5>10000,IF(D5<=1000000,B5,””),””)
B. IF(B5>10000,IF(D5<1000000,B5,0),0)
C. IF(B5>10000,IF(D5<1000000,B5,””),””)
D.   IF(IFB5>10000,IF(D5=1000000,B5,0),0)

Customer Debts 3 Outstanding 90 day balance Outstanding Total Sales 4 Bad Debt? Invoice S0 14/10/13S $100,000 $1,200,120 $50,166 $74,102 1/07/13s $21,616 $9,8552/07/13 $11,65530/06/13

Explanation / Answer

B. IF(B5>10000,IF(D5<1000000,B5,0),0) --> I go for choise B

Here the inner if condition is ture so our result is B5;

Outer If condition the is false, here we will get 0.

So ultimate result in A5 is bad debt

Bad Debt

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.