Check if the name used in the formula is defined in Name Manager. Ensure that the text values have quotation marks around them. Enable the add-in required by the used function.