IF(), AND(), and LEFT() are not working together

[gracej13]

[FONT=&quot]Hi, I am trying to combine the functions IF(), AND(), and LEFT() in a formula, however excel keeps saying #VALUE ! or #NAME ? instead of calculating the formula. This is the formula I typed, please help me find out what the problem with it is. Thank you in advance.[/FONT]
[FONT=&quot]=IF(AND(LEFT(Product_Code,2)="CW",Stock_Quantity>15*Average_Daily_Sales),25%,"") [/FONT]

 

[oldbrewer]

is Product_Code the name of a cell ?

 

[joeu2004]

Crossposted to https://www.excelforum.com/excel-fo...if-and-and-left-are-not-working-together.html, where gracej answered her own question.