If you were to write a logical if function in the cell H4 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 H15) 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.