In cell C$27$ build a formula that calculates Leonard's commission based on his sales and the commission rate. Refer to cells B$27$ and C$24$ in your formula and use appropriate relative and absolute cell references. Fill down to C$30.$ Make sure that if a new value is typed into cell C$24$ that cells C$27$:C$30$ update automatically.