chapter36
Functions in ActionParameter 1.25Function1 4.75 - =Function1(B2)A B C123SIMPLEIF IN ACTIONParameter12 1 - =SimpleIf(A3)3 15 - =SimpleIf(A4)12 1 - =SimpleIf2(A6)3 0 - =SimpleIf2(A7)12 1 - =SimpleIf3(A9)3 -16 - =SimpleIf3(A10)A B C12345678910ONE-LINE SIMPLEIF212 1 - =SimpleIf2(A2)3 0 - =SimpleIf2(A3)A B C123ASSIGNING A PARAMETER VALUEFIRSTParameter value -7SimpleIf 15 - =SimpleIf(B2)SimpleIf2 0 - =SimpleIf2(B2)SimpleIf3 -16 - =SimpleIf3(B2)A B C12345预先指定参数值Parameter value -7SimpleIf 15 - =SimpleIf(B2)SimpleIf2 0 - =SimpleIf2(B2)SimpleIf3 -16 - =SimpleIf3(B2)A B C12345BlockIf in ActionParameter-3 -1 - =BlockIf(A3)0 0 - =BlockIf(A4)13 1 - =BlockIf(A5)A B C12345NESTED IF FUNCTIONP1 P2 NestedIf(P1, P2)11 6 1 - =NestedIf(A3,B3)22 3 2-22 6 3-57.3 4 46 6 5-5 7 64 3 7A B C D123456789NESTED IF FUNCTIONP1 P2 NestedIf(P1, P2)11 6 1 - =NestedIf(A3,B3)22 3 2-22 6 3-57.3 4 46 6 5-5 7 64 3 7A B C D123456789SIMPLESELECT IN ACTIONParameter SimpleSelect0 555 - =simpleselect(A3)1 1112 222 - Notice its 222 and not 444 注意是222不是4443 3333.5 5554 4445 3336 333A B C D E12345678910c2 book excel c2.xlsBenny Czaczkes Page 10 2017/6/27THE BINOMIAL FUNCTIONp 0.5n 10x 6Binomial 0.205078125 - =Binomial(B2,B3,B4)A B C12345c2 book excel c2.xlsBenny Czaczkes Page 11 2017/6/27THE BINOMIAL FUNCTIONp 0.5n 10x 15Binomial #VALUE! - =Binomial(B2,B3,B4)A B C12345RECURSION IN ACTIONN Factorial HomeFactorial(n)0 1 - 1 1 - =HomeFactorial(A3)1 1 - =B3*A4 1 - =HomeFactorial(A4)2 2 - =B4*A5 23 6 - =B5*A6 64 24 - =B6*A7 245 120 - =B7*A8 120A B C D E12345678NewMistake In ActionX Y NewMistake1 2 0.5 - =NewMistake(A3,B3)2 1 2 - =NewMistake(A4,B4)0 1 0 - =NewMistake(A5,B5)1 0 #DIV/0! - =NewMistake(A6,B6)#NULL! In Action1 4 #NULL! - =SUM(A11:A13 B11:B13)2 5 21 - =SUM(A11:A13,B11:B13)3 6 21 - =SUM(A11:B13)#VALUE! In ActionBen #VALUE! - =A17+A18+A193 5 - =SUM(A17:A19)2#REF! In Action#REF! - #REF!#NAME! In Action#NAME? - =Benny+3#NUM! In Action#NUM! - =IRR(A33:A35,0.1)#N/A In Action3 #N/A - =VLOOKUP(2,A38:A41,1)4 2 - =VLOOKUP(2,A38:A41,1,FALSE)1 #N/A - =VLOOKUP(2,A38:A41,1,TRUE)2N o t i c e c o m m a o m i t t e d b y m i s t a k e .T h e y d o n t k n o w m e ! T h e r e i s n o S h e e t 1 i n t h i s E x c e l n o t e b o o k .注 意 遗 漏 了 逗 号在 E x c e l工 作 簿 中 没 有 S h e e t1A B C D E F1234567891011121314151617181920212223242526272829303132333435363738394041注 意 遗 漏 了 逗 号在 E x c e l工 作 簿 中 没 有 S h e e t1G1234567891011121314151617181920212223242526272829303132333435363738394041