Details
number_1 + number_2
Addition.
| Example | Output |
|---|
| =1 + 1 | 2 |
| =2 + 3 | 5 |
number_1 - number_2
Subtraction.
| Example | Output |
|---|
| =5 - 2 | 3 |
| =100 - 25 | 75 |
number_1 * number_2
Multiplication.
| Example | Output |
|---|
| =5 * 2 | 10 |
| =100 * 25 | 2500 |
number_1 / number_2
Division.
| Example | Output |
|---|
| =10 / 2 | 5 |
| =100 / 25 | 4 |
number_1 ^ number_2
Exponent.
| Example | Output |
|---|
| =2 ^ 2 | 4 |
| =10 ^ 2 | 100 |
ADD(number_1, number_2)
Add two numbers.
| Example | Output |
|---|
| =ADD(1, 1) | 2 |
| =ADD(2, 3) | 5 |
ROUND(value, places)
Round to a certain number of decimal places.
| Input Example | Output |
|---|
| =ROUND(10.563, 0) | 11 |
| =ROUND(10.563, 2) | 10.56 |
ROUNDUP(value, places)
Round up to a certain number of decimal places.
| Example | Output |
|---|
| =ROUNDUP(1.123, 0) | 2 |
| =ROUNDUP(1.123, 2) | 1.13 |
ROUNDDOWN(value, places)
Round down to a certain number of decimal places.
| Example | Output |
|---|
| =ROUNDDOWN(1.9, 0) | 1 |
| =ROUNDDOWN(2.127, 2) | 2.12 |