Tolong bantu jawabannya ya :) (soal ms.excel)

By Posted on

Tolong bantu jawabannya ya :) (soal ms.excel)

Tolong bantu jawabannya ya 🙂 (soal ms.excel)

Gaji standard (D17): =C11*C12

Gaji lembur (E17): =(C17-C11)*C12

Gaji total (F17): =D17+E17

Pot. Simp/Wajib (G17): =IF(A17="I";5000;IF(A17="II";7500;10000))

Pot. Astek (H17): =5%*F17

Pot. Pajak (I17): =IFERROR(A17="III";0);15%*F17

Total Pot (J17): =SUM(G17:I17)

Gaji Bersih (K17): =F17-J17