XLS《Cell》

FORMULA TEST DOCUMENT

1 - CELL FORMULAS 1.

1 - CONSTANT OPERANDS ,,

,,

,,

1.5 - OPERATOR PRECEDENCE ,,

,,

, 1.6 - CELL REFERENCE TOKENS 1.9 - FUNCTION TOKENS ,,

,,

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

Formula , Is , Must , Ok? ,,

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

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

1 ,

1 ,

1 ,,

=7*3+2 ,

23 ,

23 ,

1 ,,

tRef , =Q7 ,

1 ,

1 ,

1 ,

1 ,,

tFunc , =ABS(1) ,

1 ,

1 ,

1 tNum , =1.2345 , 1.2345 , 1.2345 ,

1 ,,

=7*3+(2) ,

23 ,

23 ,

1 ,,

tRef , =$Q8 ,

2 ,

2 ,

1 ,

2 ,,

tFuncVar -

1 param , =MIN(1) ,

1 ,

1 ,

1 tStr

1 ,,

=7*(3)+2 ,

23 ,

23 ,

1 ,,

tRef , =Q$9 ,

3 ,

3 ,

1 ,

3 ,,

tFuncVar -

30 params , =MIN(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30) ,

1 ,

1 ,

1 tStr , = ABC ,,

ABC ,

1 ,,

=(7)*3+2 ,

23 ,

23 ,

1 ,,

tRef , =$Q$10 ,

4 ,

4 ,

1 ,

4 ,,

tFuncVar/tMissing , =SUM(1,,

2) ,

3 ,

3 ,

1 tStr , =

2 ,,

2 ,

1 ,,

=7*(3+2) ,

35 ,

35 ,

1 ,,

tArea , =Q11:Q12 ,

5 ,

5 ,

1 ,

5 ,,

tNameX , =EDATE(DATE(2000,1,1),1) , ERROR ,

36557 , tBool , =FALSE ,

0 ,,

1 ,,

=(7*3)+2 ,

23 ,

23 ,

1 ,,

tArea , =Q11:Q12 ,

6 ,

6 ,

1 ,

6 ,,

tAttrSum , =SUM(1) ,

1 ,

1 ,

1 tBool , =TRUE ,

0 ,,

1 ,,

=(7*3+2) ,

23 ,

23 ,

1 ,,

tArea , =Q12:$Q13 ,

7 ,

7 ,

1 ,

7 ,,

tAttrSum/tRef3d , =SUM(Param:Functions!$G$22) ,

18 ,

18 ,

1 tErr(NULL) , =#NULL! , ERROR ,,

1 ,,

=7+3*2 ,

13 ,

13 ,

1 ,,

tArea , =Q13:Q$14 ,

8 ,

8 ,

1 ,

8 ,,

tFuncVar(SUM) , =SUM(1,2) ,

3 ,

3 ,

1 tErr(DIV/0) , =#DIV/0! , ERROR ,,

1 ,,

=7+(3*2) ,

13 ,

13 ,

1 ,,

tArea , =Q14:$Q$15 ,

9 ,

9 ,

1 ,

9 tErr(VALUE) , =#VALUE! , ERROR ,,

1 ,,

=(7+3)*2 ,

20 ,

20 ,

1 ,,

tArea , =$Q15:Q16 ,

10 ,

10 ,

1 ,

10 ,,

1.10 - PARENTHESES ,,

,,

tErr(REF) , =#REF! , ERROR ,,

1 ,,

=7^3*2 ,

686 ,

686 ,

1 ,,

tArea , =Q$16:Q17 ,

11 ,

11 ,

1 ,

11 ,,

Token , Formula , Is , Must , Ok? tErr(NAME) , =#NAME? , ERROR ,,

1 ,,

=7^(3*2) ,

117649 ,

117649 ,

1 ,,

tArea , =$Q$17:Q18 ,

12 ,

12 ,

1 ,

12 ,,

Constant value , =(1) ,

1 ,

1 ,

1 tErr(NUM) , =#NUM! , ERROR ,,

1 ,,

=(7^3)*2 ,

686 ,

686 ,

1 ,,

tArea , =$Q$18:$Q$19 ,

13 ,

13 ,

1 ,

13 ,,

Constant array , =({2}) ,

2 ,

2 ,

1 tErr(N/A) , =#N/A , ERROR ,,

1 ,,

=7*3^2 ,

63 ,

63 ,

1 ,,

tRef3d , =Cell!Q20 ,

14 ,

14 ,

1 ,

14 ,,

Unary operator (pre) , =(+(3)) ,

3 ,

3 ,

1 tArray , ={1} ,

1 ,

1 ,

1 ,,

=7*(3^2) ,

63 ,

63 ,

1 ,,

tArea3d , =Cell!$Q$20:$Q$21 ,

15 ,

15 ,

1 ,

15 ,,

Unary operator (post) , =((400)%) ,

4 ,

4 ,

1 tArray , ={ ABC } ,,

ABC ,

1 ,,

=(7*3)^2 ,

441 ,

441 ,

1 ,,

tRef3d , =Param!G21 ,

16 ,

16 ,

1 ,,

, Binary operator , =((2)+(3)) ,

5 ,

5 ,

1 tArray , ={TRUE} ,

0 ,,

1 ,,

=7^3+2 ,

345 ,

345 ,

1 ,,

tRef3d , =Param!$G$22 ,

17 ,

17 ,

1 ,,

, Function,

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

1 tArray , ={#VALUE!} , ERROR ,,

1 ,,

=7^(3+2) ,

16807 ,

16807 ,

1 ,,

tArea3d , =Param!$G$23:$G$24 ,