Entering Functions

Functions perform such operations as summing a range of cells, rounding, determining the square root of a number, converting a number to currency, or generating a random number. EasySpreadsheet contains several pre-defined functions that can be used when entering formulas.

Most functions use parameters. Parameters are the values, cell references, and other information required for executing the function. Parameters are enclosed in brackets after the function name. For example, the DOLLAR function is in the form DOLLAR (number, precision), and number and precision are parameters. (The DOLLAR function converts a number to currency.)  

To enter a formula that contains a function:

  1. Left-click on the cell that you wish to enter a formula into. A heavy border should appear around the cell.

  2. Type an equal sign (=). This tells EasySpreadsheet that you are entering a formula.

  3. Type the name of your function, followed by its required parameters in closed brackets. For example, if you were using the DOLLAR function for $25.00, you would enter =DOLLAR(25).

EasySpreadsheet's functions include:

Arithmetic Functions

Find sums, products, remainders, square roots, and absolute values.

Trigonometric Functions

Use sine, cosine, tangent, inverse, and hyperbolic functions. Convert from radians to degrees. Use the Pi constant.

Logarithmic and Exponential Functions

Use logarithms and natural logarithms. Use exponential functions based on the constant e.

Rounding Functions

Round numbers up or down, to even or odd numbers, to a multiples of other numbers, and to integers.

Factorials and Combinations

Determine factorials and possible combinations.

Random Numbers

Generate random numbers.

Logical Functions

Use functions that require TRUE and FALSE expressions.

Statistical Functions

Find averages, standard deviations, maximum and minimum values, and variables. Count the number of cells in a range or list.

General Text Functions

Repeat, join, or compare text strings. Remove blank spaces and non-printable characters. Determine ASCII codes. Convert strings to numbers.

Length and Position Functions

Determine the length of a text string. Return the first character, last character, of part of a string.

Format Functions

Change the case of a text string. Use number formatting, such as currency or fixed decimal.

Find and Replace Functions

Locate text within a string. Replace text in a string with new text.

Note: To view a full list of EasySpreadsheet's functions, go to the Insert menu, and click Function. A Function window will appear. Select a category from the Category box, and the available functions will appear in the Function List below. Single-click a function to view its parameters and other details. To return to your spreadsheet, click Cancel.

  1. Press the Enter key. The result of your formula will automatically appear in the cell.

 

See Also:

Inserting a Function