LEFT(chuoi, n)

RIGHT(... )

MID(chuoi,m,n) cho n ky' tu, tinh tu ky' tu thu m cua chuoi

LOWER("EXCEL")= excel

INT(-2.4)=-3

TRUNC(2.789)=2

MOD(11,3)=2 11=3*3+2

ROUND(3.1567,2)=3.16

SUMIF(vung'dk,dk,vung tong)

DSUM(datebase, field, criteria) tinh tong tren 1 cot field cua database thoa man dk trong mien tieu chuan.

COUNTIF(vung'dem',dk) dem sluong.

VLOOKUP(GT,bang GT k lay hang tieu de,cot lay du lieu,true/false) tra cuu gt voi cac gt trong cot dau tien cua bang va hien thi du lieu tuong ung trong bang tr cuu du lieu nam o cot o bien thu 3. neu gt tra cuu nho hon gt nho nhat trong cot 1st cua bang thi tra ve loi #N/A.neu bien 4=true/1 thi cac gt trong cot 1st cua bang phai dc sap xep tang dan. neu gt tra cuu khong co trong cot 1st cua bang thi ham se tra cuu gt trong bang <=gt tra cuu.

VLOOKUP(E3, $E$12:$F$16, 2, True)

HLOOKUP(GT,bang gt, hang lay du lieu,1/0)

RANK(gt xep,bang gt,1/0)

RANK(diem1hs,bangdiem,0) 0: gt nho nhay xep cuoi cung. 1: gt nho nhat xep 1st.

NOW():cho ngay & gio tai thoi diem hien tai

TODAY(): cho ngay hien tai

DAY("mm/dd/yy"): cho gt ngay

DAY("11/25/80")=25

MONTH("mm/dd/yy"): Cho gt thang

MONTH("11/25/80")=11

YEAR("mm/dd/yy"): Cho gt nam

YEAR("11/25/80")=1980

PROPER("chu hoa")=Chu Hoa. text tieng viet ketqua loi font chu.

UPPER("chu thuong")=CHU THUONG.

COUNT(VUNG) dem cac o chua so'.

COUNTA(VUNG) dem cac o khong rong.

LARGE(VUNG,K)phan tu lon thu k trong vung.

SMALL(VUNG,K)phan tu nho thu k trong vung.

MODE(1,2,3,2)=2