chapter37

FUNCTIONS IN ACTION 1Parameter Function1.1667 4.5001 15 ?AndDemo 12 15 ?AndDemo 3 - =AndDemo(B2,B3)A B C1234ANDDEMOTABLE IN ACTIONParameter1Parameter2TRUE TRUE TRUE - =AndDemoTable(A3,B3)TRUE FALSE FALSE - =AndDemoTable(A4,B4)FALSE TRUE FALSE - =AndDemoTable(A5,B5)FALSE FALSE FALSE - =AndDemoTable(A6,B6)A B C D123456ORDEMO IN ACTIONParameter1Parameter21 1 3 - =OrDemo(A3,B3)1 30 3 - =OrDemo(A4,B4)11 1 12 - =OrDemo(A5,B5)11 30 3 - =OrDemo(A6,B6)A B C D123456ORDEMOTABLE IN ACTIONParameter1Parameter2TRUE TRUE TRUE - =OrDemoTable(A3,B3)TRUE FALSE TRUE - =OrDemoTable(A4,B4)FALSE TRUE TRUE - =OrDemoTable(A5,B5)FALSE FALSE FALSE - =OrDemoTable(A6,B6)A B C D123456DOWHILEDEMO IN ACTIONN1 1 - =DoWhileDemo(A3)1.4 1 - =DoWhileDemo(A4)2 2 - =DoWhileDemo(A5)7 5040 - =DoWhileDemo(A6)8 #VALUE! - =DoWhileDemo(A7)A B C1234567DOWHILEDEMO1 IN ACTIONN1 1 - =DoWhileDemo1(A3)1.4 1 - =DoWhileDemo1(A4)2 2 - =DoWhileDemo1(A5)7 5040 - =DoWhileDemo1(A6)8 40320 - =DoWhileDemo1(A7)A B C1234567DOLOOPWHILEDEMO IN ACTIONN1 1 - =DoLoopWhileDemo(A3)1.4 1 - =DoLoopWhileDemo(A4)2 2 - =DoLoopWhileDemo(A5)7 5040 - =DoLoopWhileDemo(A6)8 40320 - =DoLoopWhileDemo(A7)A B C1234567DOUNTILDEMO IN ACTIONN1 1 - =DoUntilDemo(A3)1.4 1 - =DoUntilDemo(A4)2 2 - =DoUntilDemo(A5)7 5040 - =DoUntilDemo(A6)8 40320 - =DoUntilDemo(A7)A B C1234567DOLOOPUNTILDEMO IN ACTIONN1 1 - =DoLoopUntilDemo(A3)1.4 1 - =DoLoopUntilDemo(A4)2 2 - =DoLoopUntilDemo(A5)7 5040 - =DoLoopUntilDemo(A6)8 40320 - =DoLoopUntilDemo(A7)A B C1234567WHILEDEMO IN ACTIONN1 1 - =WhileDemo(A3)1.4 1 - =WhileDemo(A4)2 2 - =WhileDemo(A5)7 5040 - =WhileDemo(A6)8 40320 - =WhileDemo(A7)A B C1234567FORDEMO1 IN ACTIONN1 1 - =ForDemo1(A3)1.4 1 - =ForDemo1(A4)2 2 - =ForDemo1(A5)7 5040 - =ForDemo1(A6)8 40320 - =ForDemo1(A7)A B C1234567FORDEMO2 IN ACTIONN1 1 - =ForDemo2(A3)1.4 1 - =ForDemo2(A4)2 2 - =ForDemo2(A5)7 5040 - =ForDemo2(A6)8 40320 - =ForDemo2(A7)A B C1234567EXITFORDEMO IN ACTIONParameter1 Parameter25 22 15 - =ExitForDemo(A3,B3)6 22 21 - =ExitForDemo(A4,B4)7 22 28 - =ExitForDemo(A5,B5)8 22 28 - =ExitForDemo(A6,B6)A B C D123456