Excel Guides

Using Named Formulas or Constants in Excel

You can use named formulas or constants in Excel to make your formulas more readable and easier to understand. Named formulas or constants can also be used to make your formulas more reliable.

Named formulas are created by giving a formula a name. To create a named formula, select the cell in which you want the named formula to appear. Then, on the Formulas tab, in the Defined Names group, click Define Name.

In the New Name dialog box, type the name of the named formula in the Name box. In the Refers to box, type the formula that you want to name. Click OK.

You can use named constants in Excel to make your formulas more readable and easier to understand. Named constants are created by giving a constant a name. To create a named constant, select the cell in which you want the named constant to appear. Then, on the Formulas tab, in the Defined Names group, click Define Name.

In the New Name dialog box, type the name of the named constant in the Name box. In the Refers to box, type the constant that you want to name. Click OK.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.