I'm trying to figure out how to get this function in Microsoft Excel right and it's not working.

These are the Directions on the assignment

In cell F27, use an IF function to calculate the discount amount for this order based on the

customer's status (which is found in F16). If the customer's status is Preferred, the discount amount will be the Order Subtotal times the discount percentage found in cell B29; otherwise the discount amount will be 0 (zero). Hint: You will need to use a formula for the Value if True argument.

The discount amount is in cell B29 10% F16 says Preferred, the order subtotal is 116.91

I've tried using this function buts it not working and keeps giving me an error code saying theres a problem with my formula

"when the first character is an equal or minus sign excel thinks its a formula . I type =1+1 cell shows 2 to get around this use an apostrophe (') first

=IF(F16="Preferred",116.91*B29),0)

Help please