Ask Question
Computers and TechnologyComputers and Technology
25 March, 13:06

6. In cell K4, create a formula using the IF function to calculate the interest paid on the mortgage (or the difference between the total payments made each year and the total amount of mortgage principal paid each year). a. The formula should first check if the value in cell H4 (the balance remaining on the loan each year) is greater than 0. b. If the value in cell H4 is greater than 0, the formula should return the value in J4 subtracted from the value in cell D5 multiplied by 12. Use a relative cell reference to cell J4 and an absolute cell reference to cell D5. (Hint: Use 12*$D$5-J4 as the is_true argument value in the formula.) c. If the value in cell H4 is not greater than 0, the formula should return a value of 0. Copy the formula from cell K4 into the range K5:K18.

+3
Answers (1)
  1. 25 March, 14:53
    0
    a. = IF (H4>0,12*$D$5-J4,0)

    Explanation:

    a. = IF (H4>0,12*$D$5-J4,0)

    If (H4>0 is the logical test,

    12*$D$5-J4 is [value_if_true]

    0 is [value_if_false]

    b. Referencing to the above formula in (a), which is the required formula which should be typed in cell K4.

    Absolute referencing of cell D5 means that this will not change while extending this formula to the entire column. Whereas, since cell H4 and J4 have relative cell referencing, these will change relatively as we extend the formula to the entire column.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “6. In cell K4, create a formula using the IF function to calculate the interest paid on the mortgage (or the difference between the total ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers
You Might be Interested in
What types of projects require collaboration? en360
Answers (1)
A CPU has 32 KB cache, 2-way set associative, 16-byte block size. How many bits are required to use index each set in this cache?
Answers (1)
What is a Python script? 2. Explain what goes on behind the scenes when your computer runs a Python program.
Answers (2)
You support Richman Investments, a brokerage firm that employs 20 brokers. Each broker has his own client computer, and the firm has a server running Windows Server. All of the client computers are configured identically.
Answers (1)
Match each word to its correct meaning. 1. administrator set of information for an individual user of a computer, with details about access and appearance 2. control panel person responsible for running the computer and operating system 3.
Answers (1)
New Questions in Computers and Technology
If an external server needs to communicate with servers inside the green zone, which network setting on smoothwall can be opened?
Answers (1)
Detailed ___ highest risk warnings can incude identifiying which vendor updates apply to which vulnerablities as well as which types of defenses have been found to work against the specific vulnerabilities reported.
Answers (1)
As they relate to databases, which of the following describes forms? A. Forms are a type of input used to generate reports. B. Forms are a type of output used to display data generated from queries. C.
Answers (1)
What is needed to create a good problem statement?
Answers (1)
Both of the following for clauses would generate the same number of loop iterations. for num in range (4): for num in range (1, 5) :
Answers (1)
Home » Computers and Technology » 6. In cell K4, create a formula using the IF function to calculate the interest paid on the mortgage (or the difference between the total payments made each year and the total amount of mortgage principal paid each year). a.
Sign Up Forgot Password?