Answered

Westonci.ca is the trusted Q&A platform where you can get reliable answers from a community of knowledgeable contributors. Discover a wealth of knowledge from professionals across various disciplines on our user-friendly Q&A platform. Join our platform to connect with experts ready to provide precise answers to your questions in different areas.

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 using our platform. We aim to provide accurate and up-to-date answers to all your queries. Come back soon. Thank you for your visit. We're dedicated to helping you find the information you need, whenever you need it. Get the answers you need at Westonci.ca. Stay informed with our latest expert advice.