XLS《Cell》

19 ,

19 ,

1 ,,

, Function,

1 param , =(ABS((7))) ,

7 ,

7 ,

1 7^3)+2 ,

345 ,

345 ,

1 Function,

2 params , =(SUMME((3);

(5))) ,

8 ,

8 ,

1 1.2 - UNARY OPERATORS 7+3^2 ,

16 ,

16 ,

1 ,,

1.7 - CELL REFERENCE OPERATORS Cell reference , =($V$26) ,

9 ,

9 ,

1 Token , Formula , Is , Must , Ok? ,,

=7+(3^2) ,

16 ,

16 ,

1 ,,

Token , Formula , Is , Must , Ok? ,

1 ,,

Intersection , =(($V$27) ($V$27)) ,

10 ,

10 ,

1 tParen , =(1) ,

1 ,

1 ,

1 ,,

=(7+3)^2 ,

100 ,

100 ,

1 ,,

tList , =SUM((Q27:Q29,Q28:Q30)) ,

6 ,

6 ,

1 ,

1 ,,

Repeated , =((((11)))) ,

11 ,

11 ,

1 tUPlus , =+(2) ,

2 ,

2 ,

1 ,,

=2^3*4+5 ,

37 ,

37 ,

1 ,,

tIsect , =SUM(Q27:Q29 Q28:Q30) ,

2 ,

2 ,

1 ,

1 tUMinus , =-(3) , -3 , -3 ,

1 ,,

=2^3*(4+5) ,

72 ,

72 ,

1 ,,

tRange , =SUM(Q27:Q29:Q28:Q30) ,

4 ,

4 ,

1 ,

1 ,,

1.11 - SPACES ,,

,,

tPercent , =4% , 0.04 , 0.0400000381469727 ,

1 ,,

=2^(3*4)+5 ,

4101 ,

4101 ,

1 Token , Formula , Is , Must , Ok? 2^3)*4+5 ,

37 ,

37 ,

1 ,,

1.8 - CELL REFERENCE OPERATOR PRECEDENCE Constant value , =

1 ,

1 ,

1 ,

1 1.3 - BINARY OPERATORS 2^(3*4+5) ,

131072 ,

131072 ,

1 ,,

Token , Formula , Is , Must , Ok? ,,

, Constant array , = {2} ,

2 ,

2 ,

1 Token , Formula , Is , Must , Ok? ,,

=2^(3*(4+5)) ,

134217728 ,

134217728 ,

1 ,,

=SUM((Q34:Q36:Q35:Q37 Q36:Q38,Q37:Q39)) ,,

22 ,

22 ,

1 ,

1 ,,

Unary operator (pre)3) ,

3 ,

3 ,

1 tAdd , =3+2 ,

5 ,

5 ,

1 ,,

=2^((3*4)+5) ,

131072 ,

131072 ,

1 ,,

=SUM(((Q34:Q36:Q35:Q37) Q36:Q38,Q37:Q39)) ,,

22 ,

22 ,

1 ,

2 ,,

Unary operator (post) , =400 % ,

4 ,

4 ,

1 tSub , =3-2 ,

1 ,

1 ,

1 ,,

=(2^3*4)+5 ,

37 ,

37 ,

1 ,,

=SUM((Q34:Q36:(Q35:Q37 Q36:Q38),Q37:Q39)) ,,

25 ,

25 ,

1 ,

3 ,,

Binary operator , =2 +3 ,

5 ,

5 ,

1 tMul , =3*2 ,

6 ,

6 ,

1 ,,

=(2^(3*4))+5 ,

4101 ,

4101 ,

1 ,,

=SUM((Q34:Q36:Q35:Q37 (Q36:Q38,Q37:Q39))) ,,

11 ,

11 ,

1 ,

4 ,,

Function,

0 params , = PI( ) , 3.14159265358979 , 3.14159265358979 ,

1 tDiv , =3/2 , 1.5 , 1.5 ,

1 ,,

=((2^3)*4)+5 ,

37 ,

37 ,

1 ,,

=SUM(((Q34:Q36:Q35:Q37 Q36:Q38),Q37:Q39)) ,,

22 ,

22 ,

1 ,

5 ,,

Function,

1 param , = ABS(

7 ) ,

7 ,

7 ,

1 tPower , =3^2 ,

9 ,

9 ,

1 ,,

=5+4*3^2 ,

41 ,

41 ,

1 ,,

=SUM((Q34:Q36:(Q35:Q37 Q36:Q38,Q37:Q39))) ,,

21 ,

21 ,

1 ,

6 ,,

Function,

2 params , = SUM( 3,

5 ) ,

8 ,

8 ,

1 tConcat , = A &

B ,,

AB ,

1 ,,

=5+4*(3^2) ,

41 ,

41 ,

1 ,,

=SUM((Q40:Q42,Q41:Q43 Q42:Q44:Q43:Q45)) ,,

13 ,

13 ,

1 ,

1 ,,

Cell reference , = $V$40 ,

9 ,

9 ,

1 ,,

,,

,,

=5+(4*3)^2 ,

149 ,

149 ,

1 ,,

=SUM(((Q40:Q42,Q41:Q43) Q42:Q44:Q43:Q45)) ,,

10 ,

10 ,

1 ,

2 ,,

Intersection , = $V$41 $V$41 ,

10 ,

10 ,

1 1.4 - BINARY COMPARISON OPERATORS 5+4)*3^2 ,

81 ,

81 ,

1 ,,

=SUM((Q40:Q42,(Q41:Q43 Q42):Q43:Q44:Q45)) ,,

24 ,

24 ,

1 ,

3 ,,

Parentheses

11 ) ,

11 ,

11 ,

1 Token , Formula , Is , Must , Ok? ,,

=5+(4*3^2) ,

41 ,

41 ,

1 ,,

=SUM((Q40:Q42,Q41:Q43 (Q42:Q44:Q43:Q45))) ,,

13 ,

13 ,

1 ,

4 ,,

tFuncVar(IF) , = IF( FALSE,

1 ) +1 ,

1 ,

1 ,

1 tLT , =32 ,