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.
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.
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 | - |
|](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb93a4b56-e13a-4118-8823-601610d155f6%2Fae683ffc-aaf9-49c6-aa04-d30ad7502e4e%2F9wls4jh_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
![C++ Programming: From Problem Analysis to Program…](https://www.bartleby.com/isbn_cover_images/9781337102087/9781337102087_smallCoverImage.gif)
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
![C++ Programming: From Problem Analysis to Program…](https://www.bartleby.com/isbn_cover_images/9781337102087/9781337102087_smallCoverImage.gif)