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
simplify the expression below and state the value of m for which the simplified expression is not defined 2m² + m - 15/ m² - 9​
motikmotik

Answer:

  • The simplified expression is: \frac{2m-5}{m-3}
  • The simplified expression is undefined for m=3

Explanation:

The given expression is:

\frac{2m^2+m-15}{m^2-9}

The numerator can be siplified by using factorization and denominator will be simplified using the formula

a^2-b^2 = (a+b)(a-b)

So,

= \frac{2m^2+6m-5m-15}{(m)^2-(3)^2}\\=\frac{2m(m+3)-5(m+3)}{(m-3)(m+3)}\\=\frac{(2m-5)(m+3)}{(m-3)(m+3)}\\=\frac{2m-5}{m-3}

A fraction is undefined when the denominator is zero. In order to find the value of m on which the simplified fraction will be undefined we will put denominator equal to zero.

So,

m-3 = 0 => m = 3

Hence,

  • The simplified expression is: \frac{2m-5}{m-3}
  • The simplified expression is undefined for m=3
7 0
3 years ago
This is a python program.
denpristay [2]

Answer:

word = input("Type your name: ")

print(len(word))

Explanation:

The len function will count all the chars in the string.

7 0
3 years ago
Ví dụ sau sẽ in ra dữ liệu của x là kiểu gì ?
Virty [35]
Sjsjsjsjsjdhshshshshususs
7 0
2 years ago
Tim is in charge of the upcoming interschool baketball tournamnent. He wants to arrange all of the teams and their members in al
zalisa [80]
I think the answer is C.
7 0
2 years ago
(HELP ASAP) Jenae is helping her dad create a blog for his garden club. Which tool will she use?
ser-zykov [4K]
She would make use of JavaScript if she wants to make it interactive, CSS if she wants to design it, Text editor obviously for coding the blog and a web browser for the result hope this helps
7 0
3 years ago
Read 2 more answers
Other questions:
  • Suppose you have a certain amount of money in a savings account that earns compound monthly interest, and you want to calculate
    10·2 answers
  • How to connect to my wireless printer for dummies?
    12·1 answer
  • All of the following items could be too expensive for someone with only a high school degree to afford except
    6·1 answer
  • A structure that specifies which of a number of permitted data types (e.g. integers) that may be stored in its instances is:
    6·1 answer
  • Insurance can help you:
    12·1 answer
  • Reasons for the growth of decision-making systems include:
    13·1 answer
  • Identify and discuss the seven layers of the Open System Interconnection (OSI) model and their importance on TCP/IP operation.
    7·1 answer
  • What is the difference between i++ and ++ii?
    6·1 answer
  • What is the meaning of FTTH
    9·2 answers
  • Examples of how the development of coding changed the way we live. What type of technology was created as a result of code?
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!