9. In cell B15, enter a formula that uses the IF function and tests whether the total sales for Q1 (cell B8) is greater than or equal to 1000000. If the condition is true, multiply the total sales for Q1 by 0.18 to calculate a commission of 18%. If the condition is false, multiply the total sales for Q1 by 0.10 to calculate a commission of 10%.

The following pertains to smoke, inc.’s investment in debt securities: on december 31, year 3, smoke reclassified a security acquired during the year for $70,000. it had a $50,000 fair value when it was reclassified from trading to available-for-sale. an available-for-sale security costing $75,000, written down to $30,000 in year 2 because of an other-than-temporary impairment of fair value, had a $60,000 fair value on december 31, year 3. what is the net effect of the above items on smoke’s net income for the year ended december 31, year 3?