Using Labels in Excel Formulas and Functions

"Accept Labels in Formulas" Option Must Be Activated

Make sure to check the box to "Accept labels in formulas"

© Ted French

Before using labels in functions and formulas you must make sure that Accept labels in formulas is activated in the Options dialog box.

1. Choose Tools > Options from the menu.
   
   
2. The Options dialog box opens.
   
   
3. Click on the Calculations tab.
   
   
4. Make sure that the “Accept labels in formulas” option is checked.
   
   
5. Click the OK button to close the dialog box.

• Simplify Your Excel Formulas
• "Accept Labels in Formulas" Option Must Be Activated
• Add Data to the Cells
• Add a Function to the Worksheet
• Summary of Steps for Using Labels in Excel Formulas and Functions