Add numbers in a cell

To do this task, use the + (plus sign) arithmetic operator.
For example, if you type the following formula in a cell:

=5+10

The cell displays the following result: 15

Subtract numbers in a cell

To do this task, use the - (minus sign) arithmetic operator.
For example, if you type the following formula in a cell:

=10-5

The cell displays the following result: 5

Multiply numbers in a cell

To do this task, use the * (asterisk) arithmetic operator.
For example, if you type the following formula in a cell:

=5*10

The cell displays the following result: 50

Divide numbers in a cell

To do this task, use the / (forward slash) arithmetic operator.
For example, if you type the following formula in a cell:

=10/5

The cell displays the following result: 2

ROUND

Rounds a number to a certain number of decimal places.

ROUND(Number; Count)

Returns Number rounded to Count decimal places. If Count is omitted or zero, the function rounds to the nearest integer. If Count is negative, the function rounds to the nearest 10, 100, 1000, etc.

This function rounds to the nearest number.

Example

=ROUND(2.348;2) returns 2.35
=ROUND(-32.4834;3) returns -32.483. Change the cell format to see all decimals.
=ROUND(2.348;0) returns 2.
=ROUND(2.5) returns 3.
=ROUND(987.65;-2) returns 1000.

ROUNDDOWN

Rounds a number down, toward zero, to a certain precision.

ROUNDDOWN(Number; Count)

Returns Number rounded down (towards zero) to Count decimal places. If Count is omitted or zero, the function rounds down to an integer. If Count is negative, the function rounds down to the next 10, 100, 1000, etc.

This function rounds towards zero.

Example

=ROUNDDOWN(1.234;2) returns 1.23.
=ROUNDDOWN(45.67;0) returns 45.
=ROUNDDOWN(-45.67) returns -45.
=ROUNDDOWN(987.65;-2) returns 900.

ROUNDUP

Rounds a number up, away from zero, to a certain precision.

ROUNDUP(Number; Count)

Returns Number rounded up (away from zero) to Count decimal places. If Count is omitted or zero, the function rounds up to an integer. If Count is negative, the function rounds up to the next 10, 100, 1000, etc.

This function rounds away from zero.

Example

=ROUNDUP(1.1111;2) returns 1.12.
=ROUNDUP(1.2345;1) returns 1.3.
=ROUNDUP(45.67;0) returns 46.
=ROUNDUP(-45.67) returns -46.
=ROUNDUP(987.65;-2) returns 1000.

Use of parentheses

To change the order of evaluation, enclose in parentheses the part of the formula to be calculated first. For example, the following formula produces 11 because Calc calculates multiplication before addition. The formula multiplies 2 by 3 and then adds 5 to the result.

=5+2*3

In contrast, if you use parentheses to change the syntax, Calc adds 5 and 2 together and then multiplies the result by 3 to produce 21.

=(5+2)*3

In the example below, the parentheses around the first part of the formula force Excel to calculate B4+25 first and then divide the result by the sum of the values in cells D5, E5, and F5.

=(B4+25)/SUM(D5:F5)