Each column is identified by a letter (the first column is A, the second column is B…) and each row by a number (the first row is 1, the second row is 2…).
The cell reference is the combination of its column letter with its row number (A2, B5…).
To refer to consecutive cells, give the reference of the first cell, type a colon (:) and the reference of the last cell (e.g. C2:C4).
To refer to non-consecutive cells, use the semi-column as the separator (e.g. B5;D5).
Click in the result cell.
From the Table Tools - Layout tab, in the Data group, choose Formula from the list.
Delete anything already appearing in the Formula box, except the = sign.
In the Formula box, enter your formula after the = sign, using the cell references and the following mathematical operators:
-
For subtraction.
%
For percentage calculation.
/
For division.
ˆ
To raise to the power of…
*
For multiplication.
+
In this example the content of cell C6 is going to be subtracted from the content of cell C7.
If required, choose a number format from the Number format list:
#,##0
3,638
#,##0.00
3,637.54
(#,##0.00 €)
(3,637.54 €)
0
3638
0%
3638%
0.00
3637.54
0.00%
3637.54%
Click OK.
Click the cell in which you want to display the results.
From the Table Tools - Layout tab, click the Formula button.
Delete everything in the Formula box, except the = sign.
In the Paste function list, ...
Abonnement
tous les livres et vidéos ENI en illimité sans engagement
du livre imprimé ou du livre numérique