70.2K

Verified Solution

Link Copied!

INSTRUCTIONS

On Days on Market column compute the number of days that each listing was on the market. You should use a formula to do this and your formula needs to verify that the data sold occurs after the date listed. If it does, then compute the days on market. If it doesnt, display the message Check Dates. This step should be completed through the use of only one formula in one column. Hint: Use an IF formula. You will need to format the new column using the general number format and not the date format.

Using the Sale Commission Table to the right of the table, use a VLookup formula to calculate the commission for each house sold based on sales price. Hint: You will need to use an absolute reference in the table array portion of the formula to copy it to the other cells. If you result displays as a date, change the cell format to number.

What formula I can type to calculate the days on market and Commision on Excel?

Listing ID	Asking Price	Square Feet	Age	Annual Tax	Sales Price	Style	Bedroom	Bath	Date Listed	Date Sold	Days on Market	Commision
101	$ 87,400	1,236	3	707	$ 77,750	Condo	2	1	11/22/2012	4/14/2013
102	$ 110,900	1,740	4	816	$ 105,250	Victorian	2	1.5	8/23/2012	6/20/2013
103	$ 95,000	1,715	4	900	$ 95,000	Ranch	2	1.5	5/18/2013	5/22/2013
104	$ 87,000	1,273	4	638	$ 81,750	Condo	2	1	9/30/2012	5/12/2013

Answer & Explanation Solved by verified expert

See Answer