The IF function has the following syntax: $=$if$($logical test, true, false$).$

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.

$=$if$($$D$$4>=5,$"yes","no$")$

no$",$"yes"$)$

$=$if$($D$4>=5,$"yes","no$")$

$,$yes, no$)$