Inserting Constant and Formula Names

EasySpreadsheet allows you to define your own constants and formulas.

To define a constant or formula:

  1. Go to the Insert menu and move your mouse over Name.

  2. A menu will pop up. Click Define.

  3. The Define Name window will appear.

  4. Click on the Name box, then type in the name for your constant or formula. Ensure that this name has not already been used. Note also that:

  5. The formula for the name appears in the Formula box. Delete the formula in this box, then type in the value or formula. If, for example, you wanted the value of your constant to be 0.05, you would type in 0.05. If you wanted the value to be e, you would type in EXP(1). If you wanted the value to be 106, you would type in 10^6.

  6.  When you are satisfied with the name and formula, click Add. The name you entered will appear in the box below.

  7. To return to your spreadsheet, click OK.

 

Using Constants and Formulas

To use a constant or formula that you have defined, simply type its name in your usual spreadsheet formulas.

Examples: