How can we help you?

MyOffice Spreadsheet calculates formulas based on the following order of operations:

Operations enclosed in parentheses are performed first:

The order of operations depends on their priority.

Operations in the nested parentheses are performed first.

If a formula contains the parentheses that are not essential in the calculation, they will be deleted automatically. For example, the formula =SUM(1+(2*5)+1) will be automatically transformed into =SUM(1+2*5+1).

Operations outside the parentheses are performed according to their precedence.

Operations with the same precedence are performed from left to right, with the exception of the exponentiation (^), which is performed from right to left. Example: = 2^4^2 = 2^16 = 65,536.

If you combine several operators in a single formula, MyOffice Spreadsheet performs the operations in the order shown in the following table.

Priority

Operator symbol

Operator description

1

:

Range

2

 

Space

3

%

Percentage

4

+

-

 

Unary plus

Unary minus

Unary space

5

^

Exponentiation

6

*

/

Multiplication

Division

7

+

-

Addition

Subtraction

8

&

Combining two text strings into one

9

 

=

>

<

>=

<=

<>

Comparison:

Equal to

Greater than

Less than

Greater than or equal to

Less than or equal to

Not equal to

Was this helpful?
Yes
No
Previous
Formulas and functions basics
Next
Reference cells and cell ranges