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.