Question: help with the formula for #9 9. Type Days in cell O4. In cell O, build an IF formula to display the number of days

help with the formula for #9  help with the formula for #9 9. Type Days in cell
O4. In cell O, build an IF formula to display the number

9. Type Days in cell O4. In cell O, build an IF formula to display the number of days on the market. The logical_test determines if the sale date is greater than the list date. The value_if true argument is the sale date minus the list date. For the value_if_false argument, press Spacebar once in the entry box in the Function Arguments dialog box; Excel displays the space within quotation marks " " in the completed formula. This inserts a space in the cell when no sale date is available. (If you type the formula, enclose a space in quotation marks for the value_if_false) 10. Select cell A4 on the Table sheet tab and click the PivotTable button [Insert tab, Tables group]. Verify that the highlighted cell range is Table1 and that the votTable will be placed in a new worksheet. Deselect the Add this data to the ta Model box near the bottom of the dialog box. (If you select this box, you wii not be able to create a calculated field in step 13.) Name the sheet PivotTable 2. 11. Place the Listing ID field in the Rows area and the List Price and Sale Price \begin{tabular}{|c|c|} \hline 10210 & 11072 \\ \hline 10213 & 11/10A9 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!