Answered

Explore Westonci.ca, the premier Q&A site that helps you find precise answers to your questions, no matter the topic. Our platform provides a seamless experience for finding precise answers from a network of experienced professionals. Get precise and detailed answers to your questions from a knowledgeable community of experts on our Q&A platform.

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 :

MrRoyal

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

Thanks for stopping by. We are committed to providing the best answers for all your questions. See you again soon. Your visit means a lot to us. Don't hesitate to return for more reliable answers to any questions you may have. Your questions are important to us at Westonci.ca. Visit again for expert answers and reliable information.