Use the IF function to calculate the down payment starting in H11. If type = Finance, then the down payment is 10% of the amount. Else, it is equal to the amount. ### Reid Furniture Store#### Payment Information- **Required Down Payment:** 15%- **Number of Monthly Payments:** 48#### Paid-in-Full Transactions Summary (Day-wise)| Day | Weekday | Metrics ||-----|------------|---------------------------------------------------|| 1 | Sunday | 1. No. of Paid-in-Full Transactions || | | 2. Sum of Paid-in-Full Transactions || | | 3. Average of Paid-in-Full Transactions || | | 4. Average Amount Above $4,000 || | | 5. Highest Paid-in-Full Transaction Amount || 2 | Monday | || 3 | Tuesday | || 4 | Wednesday | || 5 | Thursday | || 6 | Friday | || 7 | Saturday | |#### Transaction Details| Number | Date | Weekday Number | Weekday | Department | Type | Amount | Down Payment | Balance | Last PMT Date ||----------|------------|----------------|----------|------------|----------|---------|--------------|---------|---------------|| 2021-001 | 3/1/2021 | 2 | Monday | Bedroom | Finance | 13,826 | - | 13,826 | - || 2021-002 | 3/1/2021 | 2 | Monday | Bedroom | Finance | 6,880 | - | 6,880 | - || 2021-003 | 3/1/2021 | 2 | Monday | Living Room| Finance | 8,378 | - | 8,378 | - || 2021-004 | 3/1/2021 | 2 | Monday | Living Room| Finance | 12,770 | - | 12,770 | - || 2021-005 | 3/1/2021 | 2 | Monday | Appliances | Finance | 10,496 | - | 10,496 | - ||

In the given question , The values of the column : "Down Payment" have to be evaluated based on the…

Answered: Use the IF function to calculate the…

Use the IF function to calculate the down payment starting in H11. If type = Finance, then the down payment is 10% of the amount. Else, it is equal to the amount.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Write a program to ask the user to: 1. Enter the number of courses taken. 2. Enter the total mark…

A: Program Approach: Create an integer array to store marks entered by user. Create variable n to…

Q: a. The function GET JOB below returns a job title when called. Input and run the function to see how…

A: It is defined as the process that helps to find and perform calculations on specific pieces of data…

Q: T/F 4. The == operator can always be used to test whether two values are identical when evaluating…

A: please see the next step for solution

Q: Question: For the following code: for ( a = 1, b = 5, c = 3; a < 4; a++, b++ ) { c…

A: Algorithm: Start the algorithm. Declare and initialize three integer variables: a with a value of…

Q: Question-related to R code The English Premier League (EPL) is a major soccer league in Great…

A: Actually, given information The csv data files available via the weblink provided above contain a…

Q: Mobile Service Provider A mobile phone service provider has three different data plans for its…

A: Given :

Q: Ineed help to create a nested formula in cell B17 with the IF and SUM functions that check if the…

A: For the solution of this inquiry let us take an example of relevant datasheet as below : Suppose…

Q: USe the guidelines and just show the result no need to say that your weight is over weight or…

A: // function named bmiCalculator_697 function bmiCalculator_697(m, h) { // calculate BMI return m…

Q: C++ Mobile Service ProviderModify the program in Problem 5 so that it also displays how much…

A: Code:

Q: In what situation should you overload the = operator?

A: Given: In what situation should you overload the = operator?

Q: Acme Parts runs a small factory and employs workers who are paid one of three hourly rates depending…

A: Objective: This program asks the user for hours worked and shift to display the total working hours,…

Q: Which of the statements that follow could you use to replace this if statement: if (years of…

A: Introduction Programming uses logical building pieces called if statements. They are conditional…

Q: Write a program that calculates and displays the total travel expenses of a businessperson on a…

A: Travel Expenses using functions: C++ program that calculates and displays the total travel…

Q: Write a C++ program for STC company , that asks the user to enter his "Neqaty" points and his…

A: 1)Enter your Neqaty points 2)Enter your invoice value 3)using else if ladder based on the Neqaty…

Q: Write a statement to print the data members of InventoryTag. End with newline. Ex: if itemID is 314…

Concept explainers

Control structures

Control structures are block of statements that analyze the value of variables and determine the flow of execution based on those values. When a program is running, the CPU executes the code line by line. After sometime, the program reaches the point where it has to make a decision on whether it has to go to another part of the code or repeat execution of certain part of the code. These results affect the flow of the program's code and these are called control structures.

Switch Statement

The switch statement is a key feature that is used by the programmers a lot in the world of programming and coding, as well as in information technology in general. The switch statement is a selection control mechanism that allows the variable value to change the order of the individual statements in the software execution via search.

Question

Use the IF function to calculate the down payment starting in H11. If type = Finance, then the down payment is 10% of the amount. Else, it is equal to the amount.

### Reid Furniture Store

#### Payment Information
- **Required Down Payment:** 15%
- **Number of Monthly Payments:** 48

#### Paid-in-Full Transactions Summary (Day-wise)
| Day | Weekday | Metrics |
|-----|------------|---------------------------------------------------|
| 1 | Sunday | 1. No. of Paid-in-Full Transactions |
| | | 2. Sum of Paid-in-Full Transactions |
| | | 3. Average of Paid-in-Full Transactions |
| | | 4. Average Amount Above $4,000 |
| | | 5. Highest Paid-in-Full Transaction Amount |
| 2 | Monday | |
| 3 | Tuesday | |
| 4 | Wednesday | |
| 5 | Thursday | |
| 6 | Friday | |
| 7 | Saturday | |

#### Transaction Details
| Number | Date | Weekday Number | Weekday | Department | Type | Amount | Down Payment | Balance | Last PMT Date |
|----------|------------|----------------|----------|------------|----------|---------|--------------|---------|---------------|
| 2021-001 | 3/1/2021 | 2 | Monday | Bedroom | Finance | 13,826 | - | 13,826 | - |
| 2021-002 | 3/1/2021 | 2 | Monday | Bedroom | Finance | 6,880 | - | 6,880 | - |
| 2021-003 | 3/1/2021 | 2 | Monday | Living Room| Finance | 8,378 | - | 8,378 | - |
| 2021-004 | 3/1/2021 | 2 | Monday | Living Room| Finance | 12,770 | - | 12,770 | - |
| 2021-005 | 3/1/2021 | 2 | Monday | Appliances | Finance | 10,496 | - | 10,496 | - |
|

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Given Table

VIEW

Code to Evaluate the Down Payment of each Product :

VIEW

Output

VIEW

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

IF Function Lab submission
Program Purpose - Professional Athletes often hire other professionals to help take care of matters for them. We will group them in four categories: Lawyers, Personal Assistants, Agents, and Trainers. They all get paid a percentage of the athlete's total yearly salary. Lawyers - 10%, Personal Assistants - 3%, Agents - 7%, and Trainers - 5% . Prompt the user to enter the athlete's salary for the year (ensure that the entered value is positive). The user should then enter the name and category of each of the hired professionals. The athlete should be able to hire as many professionals in each category as he/she wants, even if it is more than he/she can afford. Based on the category, calculate the amount that each professional should be paid. After all data has been entered, print the names of each professional hired, how much each is being paid, the total amount the athlete paid, and how much the athlete has left.
QUESTION 8 Re-write below JavaScript statement by utilize the arrow function abandon the usage of braces return the resulting value without using the return keyword product = function (x, y) { return x * y;} product = function (x, y) { return x * y;}
P:X B son.com/products/1 PORFbaokshelf. 13. Book Club Points Serendipity Booksellers has a book dub that awards points to its customers based on the number of books purchased cach month. The points are awarded as follows: If a customer purchases O books, he or she carns O points. • If a customer purchases I book, he or she carns 5 points. • If a customer purchases 2 books, he or she camN 15 points. • If a customer purchases 3 books, he of she carns B0 points. • If a customer purchases 4 or pore books, he or she carns 60 points, Write a program that asks the User ro ater the number of books he or she has pur- chased this month then dissays the runber oi points awarded. 14. Bank Charges A bank charges S10 per month plus Exe following check fees for a commercial checking account: S.10 cach for fewer
C++ Mobile Service ProviderModify the program in Problem 5 so that it also displays how much package A customers would save if they purchased package B or C, and how much money Package B customers would save if they purchases Package C. If there would be no savings, no message should be printed. calculate the cost of all plans (A, B, and C) based on the number of minutes the user-entered. Then based on the plan user chose, compare, and calc. the difference among the plans. this one has some error
if s=15; t=-6; r=0; u=9; how will evaluate s > t && r < u
Activity 20 Electric Bill: Using Switch Statement, write a program that will calculate and show bills of the Manila Electric Company. The rates vary depending on whether the use is residential (R), commercial( C) , or industrial (I). Any other code should be treated as an error. The program should accept the subscriber ID, Subscriber Name, his total electrical consumption in a month, and the code of the consumer type. The rates are computed as follows: R: 50 plus .50 per kwh used C: 100 for the first 1000 kwh and 0.45 for each additional kwh I: 180 for the first 1000 kwh and 0.75 for each additional kwh
Logical variables: On Time or Delayed? Complete the function WhatlsIt such that: The output logical variable on Time is true only if no Traffic is true and gasEmpty is false. The output logical variable delayed is false only if no Traffic is true and gasEmpty is false. Restriction: Logical expressions must be used. Do not use if statements. Function > 1 function [onTime, delayed] = WhatIsIt (noTraffic, gasEmpty) 2 onTime = 3 delayed = 4 5 end Save C Reset MATLAB Documentation
Hello good afternoon, Use functional decomposition to write a C++ program that asks the user to enter his or herweight and the name of a planet. Use an enumerated type called planetType to represent theplanets and use a switch statement that takes as its condition a planetType variable. The program,via the switch statement, then outputs how much the user would weigh on that planet. Thefollowing table gives the factor by which the weight must be multiplied for each planet.Your program must have the following functions in it: GetUserInput(),ConvertInputToPlanetType(), and OutputWeight() (your switch statement must be inOutputWeight()). I will let you determine what each function’s parameters and return typesshould be. The program will output an error message if the user does not type a correct planetname. The prompt and the error message will make it clear to the user how a planet name mustbe entered.Use proper formatting and appropriate comments in your code. The output must be…