102

N3=L3-72*4

104

COUNTIF(班別,B2)

106

IF(H4=H$1,$F$1,0)

COUNTIF(H4:AA4,$F$1)

G4*$F$1

108

110

202

ROUNDUP(IF(E7=$F$3,(F7-$G$3)*0.7,(F7-$G$4)*0.6),0)

204

206

ROUNDDOWN(B2,-3)

SUM(B2:D2)

ROUND(STDEV.S(B2:D2),0)

208

ROUND(AVERAGEA(E2:K2),2)

RANK.EQ(L2,$L$2:$L$311)

[<=50]0; p="">

210

VLOOKUP(REGION,Rate,2,0)*SalesAmount

302

304

306

308

Vlookup(品名,產品,3,0)

Sumif(品名,A4,數量)

310

COUNTIF(B$2:B$28,$A30)