Num Lock(Pad Lock) ( Num Lock) [ ][ ] [ ][ ]
Alt Alt 4 + ( ) 3+3 - ( ) 3-1 -1 * ( ) 3*3 / ( ) 3/3 % ( ) 20% ^ ( ) 3^2 (3*3 ) 2 TRUE FALSE = ( ) A1=B1 > ( ) A1>B1 < ( ) A1<B1 >= ( ) A1>=B1 <= ( ) A1<=B1 <> ( ) A1<>B1 "&" 1
& ( ) 2 1 "North" & "wind" "Northwind" : ( ) 2 1 B5:B15, ( ) 1 SUM(B5:B15,D5:D15) F4 F4 F4 Ex. C6 [=B6/B$18] 18 B A C6 B SUM SUM( 1, 2,...) 1, 2,... 1 30
1 2 3 SUM(3,2) = 5 SUM("3",2,TRUE) = 6 ( "3" 3 TRUE 1 ) A1 "3" B1 TRUE SUM(A1,B1,2) = 2 ( ) A2:E2 515304050 SUM(A2:C2) = 50 SUM(B2:E2,15) = 150 ABS (+-) ABS( ) ABS(2)= 2 ABS(-2) = 2 RANK RANK(,, ) ( )
0...3 2 1 0 123... RANK 10 2 5 11 7 ( 6 ) A1:A5 73.53.512 RANK(A2,A1:A5,1) = 3 RANK(A1,A1:A5,1) = 5 AVERAGE ( ) AVERAGE( 1, 2,...) 1, 2,... 1 30 0 AVERAGE 0 [ ] ([ ] - [ ]) [ ] [ ] 0
A1:A5 " " A1 10 79272 AVERAGE(A1:A5) = 11 AVERAGE( ) = 11 AVERAGE(A1:A5, 5) = 10 AVERAGE(A1:A5) = SUM(A1:A5)/COUNT(A1:A5) = 11 C1:C3 " " C1 4187 AVERAGE(, ) = 10.5 ROUND ROUND(, ) ( ) 0 ( ) ROUND(2.15,1) = 2.2 ROUND(2.149,1) = 2.1 ROUND(-1.475,2) = -1.48 ROUND(21.5,-1) = 20 ROUNDDOWN ROUNDDOWN(, ) ROUNDDOWN ROUND
( ) 0( ) ( ) ROUNDDOWN(3.2,0) = 3 ROUNDDOWN(76.9,0) = 76 ROUNDDOWN(3.14159,3) = 3.141 ROUNDDOWN(-3.14159,1) = -3.1 ROUNDDOWN(31415.92654,-2) = 31400 ROUNDUP ROUNDUP(, ) ROUNDUP ROUND ( ) 0( ) ( ) ROUNDUP(3.2,0) = 4 ROUNDUP(76.9,0) = 77 ROUNDUP(3.14159,3) = 3.142 ROUNDUP(-3.14159,1) = -3.2 ROUNDUP(31415.92654,-2) = 31500
VLOOKUP VLOOKUP HLOOKUP VLOOKUP(,,, ) ListDatabase TRUE 1 9 A Z "" "" FALSE [ ] [ ] [ ] 1 2 2 1 #VALUE! #REF! TRUE FALSE #N/A TRUE #N/A
FALSE #N/A A4:C12 " " VLOOKUP(1,,1,TRUE) = 0.946 VLOOKUP(1,,2) = 2.17 VLOOKUP(1,,3,TRUE) = 100 VLOOKUP(0.746,,3,FALSE) = 200 VLOOKUP(0.1,,2,TRUE) = #N/A (0.1 ) VLOOKUP(2,,2,TRUE) = 1.71 PHONETIC PHONETIC ( ) 1 #N/A C4 "" B7 "" PHONETIC(C4) = "" PHONETIC(B7) = "" ERROR.TYPE Excel #N/A
IF ERROR.TYPE ERROR.TYPE( ) ERROR.TYPE #NULL! 1 #DIV/0! #VALUE! #REF! #NAME? #NUM! #N/A 2 0 0 3 4 5Excel 6 7 #N/A #N/A #N/A E50 #NULL! #DIV/0! CHOOSE 2
#N/A IF(ERROR.TYPE(E50)<3,CHOOSE(ERROR.TYPE(E50)," "," ")) (1 5 )
D OK C E3 [ ][ ] [ ] OK [ ]
[ ][ ]