If you were to write a logical if function in the cell H$4$ that will give a discount $($yes$)$ for all items that has Units of $5$ or more $($assume that you will be using the copy command after writing the function to copy to H$15)$ and a no for those items that are less than five, the correct function would be$\_\_\_\_\_\_\_.$ Keep in mind relative and absolute cell references. The relative cell references will adjust for location. You must use a $ sign if you want a cell reference to remain the same as you copy the formula down the column. Also, when using text in a formula, you must use quotation marks around the text. Using the worksheet below which answer would be correct.