Minggu, 19 Februari 2012

RUMUS

=IF(D9="KEPALA HRD",1200000,IF(D9="KEPALA LAB",1350000,IF(D9=", OFFICER",1200000,IF(D9="ACCOUNTING",780000,650000))))


IF(D9="KEPALA HRD",700000,IF(D9="KEPALA LAB",750000,IF(D9="IT OFFICER",500000,IF(D9="ACCOUNTING",250000,150000))))


=E9+F9






=IF(G9>1000000,G9*10%,0)


=G9-H9

0 komentar:

Posting Komentar

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Best Web Hosting