Monday, 25 May 2015

Excel

Laporan penjualan tiket bus, menggunakan rumus excel..


Rumus excelnya:
Cell E6 (Nama Bus) =VLOOKUP(LEFT(D6,3),$B$20:C$24,2)
Cell F6 (Jurusan) =VLOOKUP(MID(D6,1,2),$B$20:$E$24,3,FALSE)
Cell G6 (Kelas) =VLOOKUP(LEFT(D6,3),$G$20:H$23,2)
Cell H6 (Tarip Dasar) =VLOOKUP(LEFT(D6,3),$B$20:$E$24,4)
Cell J6 (Harga Tiket) =SUM(H6:I6)
Posted by at
Labels:

1 comment:

  1. Nabilah Aprilia10 May 2017 at 20:29

    kak mau tanya kalo rumus tarif tambahannya gimana ya??
    saya sudah pakai rumus seperti tarif dasar tapi gabisa

    ReplyDelete

Subscribe to: Post Comments (Atom)