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

1.Operations enclosed in parentheses are performed first:

The order of operations depends on their priority.

Operations in the nested parentheses are performed first.

2.Operations outside the parentheses are performed according to their precedence.

3.Operations with the same precedence are performed from left to right.

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