/0/ 12 / /
+ 2 3 3 2 2 * 2*3 / 2/3 23 2 3 11 11 11 11 11 11 28 2468 2648
RANK SUM COUNTA SUMIF COUNTIF AVERAGE ROUND STDEVP FREQUENCY MAX LARGE MEDIAN MIN
66 6 C6:C15,,G6:G15 SUM 66
/ D17,1 SUMIF / C6:C15,,G6:G15 + +
+ / 10 0 1 / / 0 0 /
,
10 50 6-$ $17 /$ $19*10+50 615
G6,G6:G15,0 00 G6:G15 G6:G15 G6:G15,n 0 1
615 C6:C15 Null 60 615, 60 )
+ + G6:G15,K9:K15 + +
J7>=240, A, B FALS() FALSE TRUE()TRUE NOT AND 1 22, 23 23 22, 23 23 CELL(,) COUNTBLANK( ) ERROR.TYPE() INFO( ) N( ) NA() TYPE() 3 3 3
AND AND1,2, OR OR1,2, 3 80 IF AND(D4>=80,E4>=80,F4>=80),1,0) 3180 IF(OR (D4>=80,E4>=80,F4>=80),1,0) AND OR IF
1IF,, =IF(J7>=240, A, B ) =IF(J7>240,"A",IF(J7<=240,"B","C")) IF IF
PHONETIAC PHONETIAC(A6) IS ISBLANKISERROR ISEVENISODD ISLOGICALISTEXT ISNONTEXTISNUMBER ISREF ISNA( N/A) ISIF
VLOOKUP 0 VLOOKUP 0 IF A29=,,VLOOKUP(
F3=D3&E3 D3 E3 F3=D3&E3 D3 E3 F13 " "
TODAY TODAY() NOW NOW() YEAR MONTH DAY DATEVALUE NETWORKDAYS YEAR( ) 2003 MONTH( ) 12 DAY( ) 25 WEEKDAY WEEKDAY( 2003/12/25, aaaa) DATE HOUR DATEDIF DATE,, 1 DATEVALUE( 2003/4/1 ) HOUR( ) NETWORKDAYS(,,) DATEDIF,, yyyy g gg ggg e ee m mm mmm mmmm d dd ddd dddd aaa aaaa h hh m mm s ss 4 1900 2078 M,T,S,H e 1 ee 2 m1 12mm 2 01 12 Jan Dec (January) 12 (Sun) (Sunday) 12 12 12
DATEDIF DATEDIF(,, Y ) Y M D YM YD MD DATEDIF(,, Y ) TODAY() DATEDIF(,, M ) 12 DATEDIF(,, YM )