Question: Use IF Function to create conditional logic upon which conditional formatting can be applied. Complete the Loan Size column. Use an IF function in cell

Use IF Function to create conditional logic upon which conditional formatting can be applied.
Complete the "Loan Size" column.
Use an IF function in cell N3 that will display "Large Loan" if the total payments in cell L3 are greater than $10,000.
Display "Small Loan" if the total payments in cell L3 are not greater than $10,000.
Reuse your formula in cell N3 to complete the "Loan Size" column.
Apply conditional formatting to the Loan Size column to set the background fill color to blue for the cells that contain the text "Small Loan".

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

t ' s easy to get smarter about your money when you have a head start. In this assignment, you will use Excel to create a household budget to help maintain control over your finances and see how your...

Q:

Include 3 job titles FINANCIALADVISOR, locations, and starting salaries from the job search you performed. Find the average starting salary (using the AVERAGE function) Calculate and label your...

Q:

In Assignment 2, you selected either Amazon or Facebook and obtained partial financial statement information for that company. Keep that same company and complete the tab with the selected company...

Q:

The owners want to do some analysis to see how their sales are doing. Management wants to see how the company did last year and make some decisions about what products to keep along with staffing for...

Q:

My income is 15 an hour. Don't worry about the job. Please answer as much as you can or most of it in a simplified form. Anything helps. Thank You! Calculate and label your monthly income by dividing...

Q:

My income is 15 an hour. Dont worry about the job. Please anwer as much as you can or most of it in a simplified form. Anything helps. Thank You! Calculate and label your monthly income by dividing...

Q:

1. a. PROJECT STEPS Jane Bahr is a development officer at Cortona University, a private university in western Massachusetts. She is tracking the pledges received from donors in July and August and...

Q:

You are to write a lightweight web service in PHP for playing Connect Four games. The Connect Four game is a two-player connection game in which the players take turns dropping their discs from the...

Q:

You are to write a lightweight web service in PHP for playing Connect Four games. The Connect Four game is a two-player connection game in which the players take turns dropping their discs from the...

Q:

You are to write a lightweight web service in PHP for playing Connect Four games. The Connect Four game is a two-player connection game in which the players take turns dropping their discs from the...

Q:

When might a quantitatively small misstatement be considered material?

Q:

Nature House operate a commercial plant nursery where it propagates plants for garden centers throughout the region. Nature House has $4.9 million in assets. Its yearly fixed costs are $682,000, and...

Q:

Which of the following are mechanisms that help minimize agency problems? monitoring by boards of directors compensation tied to earnings and stock price transparent financial reporting the threat of...

Q:

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Q:

In the Hewlett-Packard research, discuss what options the company has if it moves away from the performance pay scheme it has previously operated.

Q:

Look up the article that is the basis for focus on research 6.1. Why do you think that some of the respondents consider that their reward strategy does not operate in practice?

Q:

In case study 6.2, what would happen if business turned down and the company made little or no gains over a pay period?