1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
lyudmila [28]
2 years ago
6

You want to calculate a bonus if the sold price was at least equal to the listing price, and if the house sold within 30 days af

ter being listed.
In cell L12, insert an IF function with a nested AND function to calculate a bonus. The AND function should ensure both conditions are met: Sold Price divided by the Listing Price is greater than or equal to 100% (cell L7) and the Days on Market are less than or equal to 30 (cell L8). If both conditions are met, the bonus is $1,000 (cell L9). Otherwise, the bonus is $0. Use mixed cell references to the input values in the range L7:L9. Copy the function to the range L12:L39.
BA Average Total Sold Highest 1 Location Sold Price Number Sold Dual Agent Total Sol Prices Sold Price Agent Codes and Commission Rates 2 Alpine Carey Buyer's Agent 2.75% 3 American Fork Hernandez DA Dual Agency 5.50% 4 Cedar Hills Pijuan SA Seller's Agent 3.25% 5 Lehi 6 Total Commission by Agent Input for Bonus 7 Carey Percent of List 100% 8 Hernandez Days on Market 30 9 Pijuan Bonus Amount $ 1,000 10 Days on Agent Number City Selling Agen Agent Type Agent Type List Price Sold Price Listing Date Sale Date Bonus 11 Market Commissio 12 1 Cedar Hills Pijuan DA Dual Agency $ 725,000 $ 705,000 4/1/2021 76 6/16/2021 13 4 Lehi Pijuan DA Dual Agency $ 350,799 $ 350,000 4/1/2021 5/25/2021 54 14 5 American Fork Pijuan DA Dual Agency $ 29 385,900 $ 385,900 4/1/2021 4/30/2021 15 6 Alpine Carey SA Seller's Agent $ 500,000 $ 495,800 68 4/3/2021 6/10/2021 16 7 Lehi Pijuan BA Buyer's Agent $ 345,999 $ 345,000 4/3/2021 59 6/1/2021 17 11 American Fork Hernandez DA Dual Agency $ 325,000 $ 320,000 48 4/12/2021 5/30/2021 18 Alpine 12 Pijuan DA Dual Agency $ 750,250 $ 725,900 4/12/2021 11/1/2021 203 19 $ DA 17 Alpine Dual Agency $ Carey 645,000 66 643,000 4/18/2021 6/23/2021 20 19 American Fork Pijuan BA Buyer's Agent $ 425,000 $ 415,000 4/18/2021 6/30/2021 73 21 21 Lehi Pijuan SA Seller's Agent $ 325,000 $ 330,000 4/28/2021 6/1/2021 34 22 24 American Fork Pijuan SA Seller's Agent $ 425,815 $ 418,000 4/28/2021 140 9/15/2021 23 27 Alpine DA Pijuan Dual Agency $ 700,000 $ 705,000 4/30/2021 6/19/2021 50 24 30 Lehi Hernandez SA Seller's Agent $ 365,000 $ 363,000 5/1/2021 6/18/2021 48 25 32 Cedar Hills Carey SA Seller's Agent $ 885,500 $ 800,000 5/1/2021 6/6/2021 36 26 34 Cedar Hills Carey SA Seller's Agent $ 610,000 $ 600,000 5/1/2021 6/26/2021 56 27 35 Cedar Hills Hernandez DA Dual Agency $ 560,700 $ 565,000 5/1/2021 5/30/2021 29 29 36 American Fork Hernandez BA . Buyer's Agent $ 450,000 $ 450,000 5/2/2021 9/30/2021 151 29 43 American Fork Carey BA 9 Buyer's Agent $ 375,000 $ 372,500 5/6/2021 5/15/2021 30 46 Cedar Hills Carey SA Seller's Agent $ 650,000 $ 625,750 5/15/2021 679/2021 25 48 31 Alpine Hernandez DA Dual Agency $ 545,000 $ 560,000 5/22/2021 6/16/2021 25 32 Lehi 53 Carey SA Seller's Agent $ 315,750 $ 320,000 5/28/2021 6/18/2021 21 33 61 Lehi Carey DA Dual Agency $ 300,000 $ 300,000 6/2/2021 9/2/2021 92 34 Alpine 69 Hernandez DA Dual Agency $ 589,000 $ 595,000 20 6/18/2021 7/8/2021 35 70 American Fork Hernandez DA Dual Agency $ 345,670 $ 102 345,000 6/20/2021 9/30/2021 36 73 Cedar Hills Carey BA Buyer's agent $ 555,000 $ 550,000 6 6/24/2021 6/30/2021 37 75 Alpine Carey BA Buyer's Agent $ 475,000 $ 485,000 86 6/24/2021 9/18/2021 38 78 American Fork Carey DA Dual Agency $ 400,000 $ 15 400,000 6/30/2021 7/15/2021 39 80 American Fork Pijuan SA Seller's Agent $ 380,500 $ 365,750 6/30/2021 63 9/1/2021 40 41 42 43 44 Details Map Loan +
Computers and Technology
1 answer:
erma4kov [3.2K]2 years ago
8 0

Answer:

Following are the solution to the given question:

Explanation:

Please find the following Excel form for calculating the bonus as required. Please ensure the equation is duplicated even so, with the sign "=." It is possible to insert this formula into cell L12. Then cut/paste the cell into other L12:L39 cells.

=IF(AND(G12/F12 \geq \$L \$7,J12 \leq \$L\$8)=TRUE,\$L\$9,0)

The mixed microbial reference here is used in L7, L8, and L9 so these cell references are not moved whenever the formula is copied to L12:L39.

Please verify that whenever the copy has also been copied, the cell formula appears beneath in each cell.

It must be as below in L12.

=IF(AND(G12/F12 \geq \$L\$7,J12\leq \$L\$8)=TRUE,\$L\$9,0)

It must be as follows in L13.

=IF(AND(G13/F13\geq \$L\$7,J13\leq \$L\$8)=TRUE,\$L\$9,0)

and so on.

You might be interested in
In Java, it is possible to create an infinite loop out of while and do loops, but not for-loops. true or false
soldier1979 [14.2K]

Answer:

False is the correct answer for the above question.

Explanation:

  • In java programming language or any other programming language, any loop can be infinite.
  • It is because the infinite loop is called for that loop which is not run in a finite number of times.
  • The loop is used to repeat some lines in a finite number of times. Any loop has three things- first is the initial value which tells the loop to start, The second is the condition check which states when the loop will stop and the third is an operation which directs some variable, so that the condition may be false after some finite amount of time.
  • If the condition will not false in any iteration of the loop, then the loop can proceed for an infinite amount of time.
  • The above-question states that the while loop and do while loop can be infinite which is a true statement.
  • But it also states that the 'for' loop can not be infinite which is not a correct statement which is described above. Hence false is the correct answer to the above question.
8 0
3 years ago
1. Railroad tracks present no problems for a motorcyclist.
Yuki888 [10]

Answer: 1 is A

2 is D

Explanation:

3 0
2 years ago
Problems and Exercises 16 through 43 are based on the entire ("big" version) Pine Valley Furniture Company database. Note: Depen
lesya [120]

Answer:

SQL queries

The command used to display the customer ID and total number of orders placed is given below

Query:

SELECT CustomerID, COUNT (orderID) AS TotalOrders

FROM Order_Table

GROUP BY CustomerID

Explanation:

SQL queries

The command used to display the customer ID and total number of orders placed is given below

Query:

SELECT CustomerID, COUNT (orderID) AS TotalOrders

FROM Order_Table

GROUP BY CustomerID

SELECT - To query the database and get back the specified fields SQL uses the select statement

CustomerID is a coloumn name

The function COUNT(OrderID) returns the number of orders

Totalorderds is a label

FROM - To query the database and get back the preferred information by specifying the table name

Order_Table is a table name

GROUP BY - The clause is used to group the result of a SELECT statement done on a table where the tuple values are similar for more than one column

The table below displays the CustomerID and total number of orders placed

CustomerID                                              Totalorders

4                                                                    28

1                                                                      6

12                                                                    5

16                                                                    5

6                                                                     3

9                                                                     3

15                                                                    3

3                                                                     1

13                                                                    1

14                                                                    1

The table below shows the total number of orders situated for each sales person

SalesPerson_ID                                         TotalOrders

3                                                                    16

2                                                                     3

4                                                                     3

5                                                                     3

3 0
3 years ago
What is a office buttom?
SpyIntel [72]
The Microsoft button was exclusively used in the 2007 versions of word, excel, powerpoint, access and outlook. It has all of the different options like to save, print, open ect. It was located in the top left hand corner of the screen. It looked a bit like this (see attachment).

3 0
3 years ago
What does it mean to read visual and audio text
solniwko [45]

Talking books could be a means to automatize and generalize such an audio–visual reading experience. ... RWL consists of an experimental reading situation where one reads a text while one can hear it said aloud by a prerecorded speaker or by a text-to-speech system.


5 0
3 years ago
Other questions:
  • Describe the indicators and hazards of a metal deck roof fire in an unprotected steel joist warehouse as well as the techniques
    6·1 answer
  • What percentage of jobs work in the entertainment industry?
    13·1 answer
  • Correspondence involves verbal communication. True False
    6·2 answers
  • A ______ connection provides fast internet service and the ability to exchange large files. ​
    11·1 answer
  • A computer’s memory is composed of 8K words of 32 bits each. How many bits are required for memory addressing if the smallest ad
    10·1 answer
  • Why are the READ and DATA statements used<br>together?​
    10·1 answer
  • Consider the following statement from the CS Principles course framework: The global distribution of computing resources raises
    12·1 answer
  • ou use productivity apps on your iPad tablet device while traveling between client sites. You're concerned that you may lose you
    11·1 answer
  • What would happen if computers only had input devices?
    9·1 answer
  • Overview In this assignment, you will gain more practice with designing a program. Specifically, you will create pseudocode for
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!