Cara Mudah Membuat Graviks dan Font TallyMark di Userform

Untuk front Tally Marks dan Sampel file xlsm
dapat di unduh >>>  DISINI

Silahkan  silahkan extrak fornt tally – mark  dan

pastekan pada widows Pilih front

Rumus Pecah angka setiap nilai 5

=REPT(5,INT(B3/5))&MOD(B3,5)

Rumus cell to kolom

=MID($C$3,COLUMNS($C3:C3),1)

=MID($C$3,COLUMNS($C3:D3),1)

=MID($C$3,COLUMNS($C3:E3),1)

=MID($C$3,COLUMNS($C3:F3),1)

Fungsi if :

=IF(D3="1","A",IF(D3="2","B",IF(D3="3","C",IF(D3="4","D",IF(D3="5","E","")))))

Demikian semoga bermanfaat !