JENIS BONUS NILAI BONUS Bil Nama Alamat Gaji Bonus Bonus Gaji Bonus 1 Encik

Jenis bonus nilai bonus bil nama alamat gaji bonus

This preview shows page 1 - 3 out of 3 pages.

JENIS BONUS NILAI BONUS
Image of page 1
Bil Nama Alamat Gaji % Bonus Bonus Gaji +Bonus 1 Encik Fuad Azman No 45 Kampung Bahagia, 06010, Jitra Kedah 6510 =VLOOKUP(D2,B16:C18,2,TRUE) =E2*D2+2000 =D2+F2 2 Puan Noraziah Harun Puan Noraziah Harun No 23 Jln Tengas 3, Taman Tengas, 06010 Changlun Kedah 5510 =VLOOKUP(D3,B16:C18,2,TRUE) =E3*D3+2000 =D3+F3 3 Encik Zabidi Hassan No 56, Jln Sesak 2, Taman Sesak, 06010 Changlun Kedah 880 =VLOOKUP(D4,B16:C18,2,TRUE) =E4*D4+2000 =D4+F4 4 Cik Maziah Rabu No 33, Jln Kaya 5, Taman Kaya, 06010 Changlun Kedah 1250 =VLOOKUP(D5,B16:C18,2,TRUE) =E5*D5+2000 =D5+F5 5 Encik Hambali Mohamad No 100, Kampung Idaman, 06010, Jitra Kedah 955 =VLOOKUP(D6,B16:C18,2,TRUE) =E6*D6+2000 =D6+F6 6 Encik Bakaruddin Ali No 45, Jln Suria 8, Taman Suria, 06010, Jitra Kedah 2465 =VLOOKUP(D7,B16:C18,2,TRUE) =E7*D7+2000 =F7+D7 7 Encik Hassan Azhar No 67, Kampung Selamat Maju, 16010, Napoh, Kedah 2555 =VLOOKUP(D8,B16:C18,2,TRUE) =E8*D8+2000 =D8+F8 8 Encik Hisham Mamat No 55, Jalan Likoh 4, Taman Likoh, 06010, Bukit Kayu Hitam Kedah 4210 =VLOOKUP(D9,B16:C18,2,TRUE) =E9*D9+2000 =D9+F9 9 Puan Zuhanari Samat Lot 333, Kampung Sentol, 06010 Changlun Kedah 750 =VLOOKUP(D10,B16:C18,2,TRUE) =E10*D10+2000 =D10+F10 10 Encik Nizar Mohd. Saad Lot 878, Kampung Tolak, 06010, Changlun Kedah 879.2 =VLOOKUP(D11,B16:C18,2,TRUE) =E11*D11+2000 =D11+F11 11 Tuan Haji Azmin Rahman No 12, Jalan Indah 2, Taman Bukit Indah, Jitra Kedah 9900 =VLOOKUP(D12,B16:C18,2,TRUE) =E12*D12+2000 =D12+F12 Jumlah Bonus =SUM(F2:F12) 0 0.75 =COUNTIF(E2:E12,C16) Bonus Tertinggi =MAX(F2:F12) 1000 0.5 =COUNTIF(E2:E12,C17) Bonus Terendah =MIN(F2:F12) 5000 0.25 =COUNTIF(E2:E12,C18) Purata Bonus =AVERAGE(F2:F12) KATEGORI GAJI PERATUS BONUS BILANGAN KATEGORI JENIS BONUS NILAI BONUS
Image of page 2
Bonus Tertinggi Bonus Terendah Purata Bonus
Image of page 3

You've reached the end of your free preview.

Want to read all 3 pages?

  • Fall '17

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes