Answered

IDNLearn.com is the perfect place to get detailed and accurate answers to your questions. Get comprehensive answers to all your questions from our network of experienced experts.

Display the Approval Form worksheet and create an IF statement in cell B13 to determine if the applicant is eligible for a personal loan. Use the criteria below as part of your logic statement:

Sagot :

MrRoyalidn

Excel formulas are expressions used to perform computation.

The Excel formula to enter in cell B13 is =IF(B9 < 600, "Denied","Approved)

From the question, we have:

  • Cell B13 represents the applicant's eligibility status
  • Cell B9 represents the credit score

The eligibility criteria are given as:

  • Credit Score < 600 = “Denied”
  • Credit Score >= 600 = “Approved”

To write the formula, we make use of an IF function

An IF function in Microsoft Office Excel has the following syntax

=IF([condition],[value if true],[value if false]).

So, the required formula to enter in cell B13 is:

=IF(B9 < 600, "Denied","Approved)

Read more about Excel formulas at:

https://brainly.com/question/25683602

We appreciate your contributions to this forum. Don't forget to check back for the latest answers. Keep asking, answering, and sharing useful information. Thank you for choosing IDNLearn.com. We’re dedicated to providing clear answers, so visit us again for more solutions.