Sommaire

Making calculations

Basic principles

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).

Entering a calculation formula

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.

+

For addition.

In this example the content of cell C6 is going to be subtracted from the content of cell C7.

images/23RBEN11.png

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.

Using an integrated function in a table

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, ...