Excel

BUANG OBJEK YANG TIDAK PERLU

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1,"-","")," ",""),"+",""),".",""),"(",""),")","")

TAMBAH "6" DEPAN OBJEK

=IF(LEFT(C1,1)="6",C1,"6"&C1)

CARI JULAT/ANGGARAN JUMLAH

=AVERAGE(A2:A7)

#boleh guna untuk ("=sum("), ("=count(" for count table that have number cell), ("=counta(" for count table that have all cell)

CARI JUMLAH TERTENTU

=SUMIF(A2:A9,A12,B2:B9)

#=COUNTIF(A2:A9,A12) cari jumlah orang tu dah beli berapa kali

GABUNGKAN 2 CELL DAN ADA SENGKANG DIANTARANYA

=CONCATENATE(A2," ",B2)

BENAR ATAU TIDAK

=IF(A2="ali",TRUE,FALSE) @ =IF(A2="ali","yes","no way")