Latihan Vlookup Dan Hlookup.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Latihan Vlookup Dan Hlookup.xlsx as PDF for free.
More details
- Words: 144
- Pages: 1
Soal VLOOKUP dan HLOOKUP Bagian Operator NO 1 2 3 4 5 6 7 8 9 10
Gol 1A 1B 1B 1C 1A 1A 1C 1B 1B 1A
Nama Pegawai Jejen Dina Doni Ucok Fitri Didi Ceps Deta Izal Kaka Total
Gaji Pokok 600,000 800,000 800,000 1,000,000 600,000 600,000 1,000,000 800,000 800,000 600,000 7,600,000
Gaji Tunjangan Transpotasi 50,000 100,000 70,000 100,000 70,000 100,000 120,000 100,000 50,000 100,000 50,000 100,000 120,000 100,000 70,000 100,000 70,000 100,000 50,000 100,000 720,000 1,000,000
Tabel Gaji GOL Gaji Pokok Tunjangan Transportasi 1A 600,000 50,000 100,000 1B 800,000 70,000 100,000 1C 1,000,000 120,000 100,000
Total Gaji
Pajak
750,000 12,000 970,000 24,000 970,000 24,000 1,220,000 40,000 750,000 12,000 750,000 12,000 1,220,000 40,000 970,000 24,000 970,000 24,000 750,000 12,000 9,320,000 224,000
Tabel Pajak 1A 2%
1B 3%
Gaji Bersih 738,000 946,000 946,000 1,180,000 738,000 738,000 1,180,000 946,000 946,000 738,000 9,096,000
1C 4%
Gol 1A 1B 1B 1C 1A 1A 1C 1B 1B 1A
Nama Pegawai Jejen Dina Doni Ucok Fitri Didi Ceps Deta Izal Kaka Total
Gaji Pokok 600,000 800,000 800,000 1,000,000 600,000 600,000 1,000,000 800,000 800,000 600,000 7,600,000
Gaji Tunjangan Transpotasi 50,000 100,000 70,000 100,000 70,000 100,000 120,000 100,000 50,000 100,000 50,000 100,000 120,000 100,000 70,000 100,000 70,000 100,000 50,000 100,000 720,000 1,000,000
Tabel Gaji GOL Gaji Pokok Tunjangan Transportasi 1A 600,000 50,000 100,000 1B 800,000 70,000 100,000 1C 1,000,000 120,000 100,000
Total Gaji
Pajak
750,000 12,000 970,000 24,000 970,000 24,000 1,220,000 40,000 750,000 12,000 750,000 12,000 1,220,000 40,000 970,000 24,000 970,000 24,000 750,000 12,000 9,320,000 224,000
Tabel Pajak 1A 2%
1B 3%
Gaji Bersih 738,000 946,000 946,000 1,180,000 738,000 738,000 1,180,000 946,000 946,000 738,000 9,096,000
1C 4%
Related Documents
Latihan Vlookup Dan Hlookup.xlsx
October 2019 11
08 Excel Vlookup Dan Hlookup
November 2019 13
09 Excel Vlookup Dan If
November 2019 11
Vlookup&hlookup.xlsx
April 2020 8
Excel - Vlookup
October 2019 10
Vlookup Instructions
December 2019 14More Documents from "Tim Otero"
Bab Ii Maternitas.docx
October 2019 6
Latihan Vlookup Dan Hlookup.xlsx
October 2019 11
Parameter.pdf
May 2020 6
Time Schedule Pemilihan Ketua Pemudaok.xlsx
May 2020 7
Time Schedule Pemilihan Ketua Pemudaok.xlsx
April 2020 5