DouglasBank is a small boutique bank based out of Vancouver, BC that receives th

Question

DouglasBank is a small boutique bank based out of Vancouver, BC that receives thousands of credit card applications each year. It has had tremendous success by extending credit only to customers whose current account balances exceed the amount of credit card debt that they have at the time of their application. DouglasBank managers want to use Excel to determine whether they should "accept" or reject" each application. Using the information below, what is the correct formula that should be entered in cell D2?

Explanation / Answer

The formula you need to write in D2 is

=IF(B:B >C:C,"accept","reject")

Following is the screenshot of the spreadsheet

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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