enter a formula in cell b10 to return a value of 35000 if the net profit after tax (cell B() is greater than or equal to 350000 or 1000 if it is not.
Added by Natalia W.
Step 1
We can use the IF function for this. The formula will look like this: Show more…
Show all steps
Your feedback will help us improve your experience
Syed Vasi and 51 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Akash M.
Text: Complete the "Down OK?" column. Use nested IF functions in cell K5. Include an AND function as part of the criteria in the second IF function. Return Yes if the "Down Payment" (cell F5) exceeds 10% of the "Loan Amount" (cell D5) or if the "Down Payment" exceeds 5% of the "Loan Amount" and the "PMT/Income" ratio (cell E5) is less than 40%. Otherwise, return No. Copy your formula down to complete the "Down OK?" column.
In cell B13, create a formula using the VLOOKUP function that looks up the value from cell A11 in the range A5:B7, returns the value in column 2, and specifies an exact match. Copy the formula to cell E13.
Eric C.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Watch the video solution with this free unlock.
EMAIL
PASSWORD