I want to multiply a value by a percentage. In some cases, we need to enter the word "Special" instead of the calculation.I am getting the #Value! error, I am not sure if this is...