Feeds:
Posts
Comments

Posts Tagged ‘excel’

Capture

Read Full Post »

Read Full Post »

untitled  2

Read Full Post »

Autosave Excel

Read Full Post »

= LEFT (E2,LEN(E2)-2)
Hapus karater 2 hurup dari kiri

Note : settingan system dan regional Di control panel berpengaruh dengan format penulisan formula , seperti , (koma) dan ;(Titik koma)

Read Full Post »

Vlookup Excel

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

=VLOOKUP(A7;G2:I8;3;0)

Read Full Post »

Contoh :

cell A4 = “0004653”

Solusi

= Value (A4) = 4653

Read Full Post »

Older Posts »