Cell can be filled with formula. Writing begins with an equal sign (=). If on a cell we start with the = sign then Excel will automatically perform calculations on those cells. For example, if we fill a cell with text 3 +7 then the cell will contain text 3 +7. But if we fill the cell with shape = 3 +7 then displayed the results on these cells, namely 10. While we give the formula-ie "= 3 +7" - shown in the formula bar.
Another example is if cell A1 contains the value 5. We want to show the value of cell A2 is multiplied by 9. So we fill in the A2 cell with = A1 * 9.
We can use mathematical operators to create a formula. The following mathematical operators that we can use.
| Operator | ||
|---|---|---|
| Multiplication | : | * |
| Distribution | : | / |
| Addition | : | + |
| Reduction | : | - |
| Powers | : | ^ |
| Grouping operations | : | () |
| Percentage | : | % |
For the record calculated multiplication and division precede addition or subtraction. For example, 5 +7 * 10 +70 ie the result is 5 75. If we wish for 5 +7 calculated in advance so we use parentheses. So the writing is (5 +7) * 10 that the result is 350.
Here are some examples of functions and syntax (form of writing) which may be often we use. If we need or want to find other formulas provided by Microsoft Excel, we can see on the Paste Function dialog box by clicking on "More Function ....."
Here are some examples of functions and syntax (form of writing) which may be often we use. If we need or want to find other formulas provided by Microsoft Excel, we can see on the Paste Function dialog box by clicking on "More Function ....."
