"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 the material useful?
Yes
No
Users found this material useful: 0 из 0