On the Transactions worksheet, in cell P$10,$ create a formula that will return $0\mathrm{.}1$ if the customer is a member and they either purchased a promotional item or spent more than $$100,$ otherwise return a value of $0.$ Format the cell as Percentage with $0$ decimal places. Use the fill handle to copy the formula down through P$30.$