Formulas offer a quick way to find the sum of a few digits.
In row 2, the result is computed using an addition formula, =5+5.
For example, =A3+B3.
The results of the formula update automatically when the data changes.
This approach reduces the possibility of errors created by typing the wrong cell reference.
Select cellA3to add that cell reference to the formula after the equal sign.
key in theplus sign into the formula after A3.
Select cellB3to add that cell reference to the formula after the addition sign.
PressEnterto complete the formula.
The answer 20 appears in cell C3.
grab the cell to display the formula in theformula barabove the worksheet.
The simplest Fibonacci sequence, shown in the image above, begins with the numbers zero and one.
The steps below detail how to create a simple Fibonacci sequence using a formula.
Each iteration, or copy, of the formula adds together the previous two numbers in the sequence.
In cell A2, type1and pressEnter.
In cell A3, punch in the formula=A1+A2and pressEnter.
Select cellA3to make it theactive cell.
The pointer changes to a black plus sign when it is over the fill handle.
Drag the fill handledown to cell A19.
Cell A19 contains the number 2584.
And example of subtracting cell A13 from C21 would look like this:=C21-A13.
see to it you remember theorder of operations when it comes to arithmetic.
To divide the sum of two cells, the formula could look like=(A17+B21)/D2.
