tugas aplikom GAJI POKOK

RUMUS GAJI POKOK
=IF(D3>20,3000000,IF(D3>15,2000000,IF(D3>10,15000000,IF(D3>5,1000000,0))))


RUMUS TUNJANGAN
=IF(D4>20,3000000,IF(D4>15,2000000,IF(D4>10,15000000,IF(D4>5,1000000,0))))