Cell Formulas

On this page, you will learn how to make changes to cells with Cell Formulas.

Formulas

To modify cells using Cell Formulas, you must edit a cell that contains a numeric measure. This feature allows you to perform calculations directly based on the existing value in the cell.

Example: Adding 10% to a cell

Suppose a cell contains the value 1000, and you want to increase it by 10%. To do this:

1. Select the cell you want to edit.

2. Enter the formula:

    =+10%

    Here is the breakdown:

    • Start with an equal sign ( = ).
    • Follow it with an operator (+, -, *, or /).
    • Add a number (e.g., 10) and optionally, the percentage symbol ( % ).

3. Submit the formula.

If you follow this syntax you will quicly adjust cell values using calculations, and in this case, the value will become 1100.

Updated over a week ago