At Westonci.ca, we connect you with the answers you need, thanks to our active and informed community. Explore in-depth answers to your questions from a knowledgeable community of experts across different fields. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.
Sagot :
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 service. We aim to provide the most accurate answers for all your queries. Visit us again for more insights. We hope our answers were useful. Return anytime for more information and answers to any other questions you have. Thank you for choosing Westonci.ca as your information source. We look forward to your next visit.