Selamat Datang Di Blog Yoel Rananda.S

Selamat Datang Di Blog Yoel Rananda.S Welcome To my Blog..

hujan salju

Minggu, 13 Mei 2012

Soal if combinasi left, and right

rumus1
=SUM(H7*E7)
rumus2
=IF(E7>26;10%*I7;IF(E7>51;15%*I7;5%*I7))
rumus3 =SUM(I7-J7)
rumus4
=IF(LEFT(D7;1)="A";"lutfi";IF(LEFT(D7;1)="B";"amir";"nurbaiti"))
Rumus5
=IF(RIGHT(D7;1)="1";"Pemula";"Menengah")

Download:

Tidak ada komentar:

Posting Komentar

Popular Posts

Main Menu

Blogroll

Blogger news