EasySpreadsheet allows you to define your own constants and formulas.
To define a constant or formula:
Go to the Insert menu and move your mouse over Name.
A menu will pop up. Click Define.
The Define Name window will appear.
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:
Names can contain uppercase and lowercase letters.
Names can contain numbers, but cannot begin with numbers.
Names can contain underscores.
Names cannot contain spaces.
Names cannot contain symbols.
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.
When you are satisfied with the name and formula, click Add. The name you entered will appear in the box below.
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:
Suppose that you have defined a constant with the name TaxRate and the value 0.08. Suppose also that you wanted to multiply this value by the value in A3. Instead of entering the formula =A3*0.08, you could enter =A3*TaxRate.
Suppose that you have defined a formula with the name RANDOM. Suppose also that the formula for random is ROUND(RAND()*9+1, 0), which generates a random whole number between 1 and 10. Instead of retyping the formula in your spreadsheet each time you want a random number, you could enter =RANDOM.