[belajar-excel] Hitung Bonus Tambahan untuk Petugas Kring [1 Attachment]

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Hitung Bonus Tambahan untuk Petugas Kring [1 Attachment]

Edhie Wibowo
Selamat Siang semua rekan2,
mohon ijin utk bertanya ttg rumus IF bertingkat di kolom "I"
untuk memberikan uang bonus penghargaan kepada petugas Kring PBB.
Ketentuan bonus:
Untuk pelunasan bln Juli 2019 = Rp.325.000,-
Untuk pelunasan bln Juni 2019 = Rp.400.000,-
Untuk pelunasan bln Mei 2019 = Rp.450.000,-
Untuk pelunasan bln April 2019 = Rp.400.000,-

Saya coba memakai formula "IF" tapi kok error, mohon
pencerahannya.

Trims sebelumnya.

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

rumus hitung bonus.xlsx (12K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Hitung Bonus Tambahan untuk Petugas Kring

ghozi alkatiri
 mungkin rumus untuk J2  yang benar adalah =IF(G2=MONTH=7,325000, IF(G2=MONTH=6,400000, IF(G2=MONTH=5,450000, IF(G2=MONTH=4,500000,"zonk"))))


wassalam 
Ghozi Alkatiri    Pada Rabu, 30 Oktober 2019 22.38.14 WIB, Edhie Wibowo [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    
Selamat Siang semua rekan2,
mohon ijin utk bertanya ttg rumus IF bertingkat di kolom "I"
untuk memberikan uang bonus penghargaan kepada petugas Kring PBB.
Ketentuan bonus:
Untuk pelunasan bln Juli 2019 = Rp.325.000,-
Untuk pelunasan bln Juni 2019 = Rp.400.000,-
Untuk pelunasan bln Mei 2019 = Rp.450.000,-
Untuk pelunasan bln April 2019 = Rp.400.000,-

Saya coba memakai formula "IF" tapi kok error, mohon
pencerahannya.

Trims sebelumnya.

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

  #yiv7265349575 #yiv7265349575 -- #yiv7265349575ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7265349575 #yiv7265349575ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7265349575 #yiv7265349575ygrp-mkp #yiv7265349575hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7265349575 #yiv7265349575ygrp-mkp #yiv7265349575ads {margin-bottom:10px;}#yiv7265349575 #yiv7265349575ygrp-mkp .yiv7265349575ad {padding:0 0;}#yiv7265349575 #yiv7265349575ygrp-mkp .yiv7265349575ad p {margin:0;}#yiv7265349575 #yiv7265349575ygrp-mkp .yiv7265349575ad a {color:#0000ff;text-decoration:none;}#yiv7265349575 #yiv7265349575ygrp-sponsor #yiv7265349575ygrp-lc {font-family:Arial;}#yiv7265349575 #yiv7265349575ygrp-sponsor #yiv7265349575ygrp-lc #yiv7265349575hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7265349575 #yiv7265349575ygrp-sponsor #yiv7265349575ygrp-lc .yiv7265349575ad {margin-bottom:10px;padding:0 0;}#yiv7265349575 #yiv7265349575actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7265349575 #yiv7265349575activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7265349575 #yiv7265349575activity span {font-weight:700;}#yiv7265349575 #yiv7265349575activity span:first-child {text-transform:uppercase;}#yiv7265349575 #yiv7265349575activity span a {color:#5085b6;text-decoration:none;}#yiv7265349575 #yiv7265349575activity span span {color:#ff7900;}#yiv7265349575 #yiv7265349575activity span .yiv7265349575underline {text-decoration:underline;}#yiv7265349575 .yiv7265349575attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7265349575 .yiv7265349575attach div a {text-decoration:none;}#yiv7265349575 .yiv7265349575attach img {border:none;padding-right:5px;}#yiv7265349575 .yiv7265349575attach label {display:block;margin-bottom:5px;}#yiv7265349575 .yiv7265349575attach label a {text-decoration:none;}#yiv7265349575 blockquote {margin:0 0 0 4px;}#yiv7265349575 .yiv7265349575bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7265349575 .yiv7265349575bold a {text-decoration:none;}#yiv7265349575 dd.yiv7265349575last p a {font-family:Verdana;font-weight:700;}#yiv7265349575 dd.yiv7265349575last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7265349575 dd.yiv7265349575last p span.yiv7265349575yshortcuts {margin-right:0;}#yiv7265349575 div.yiv7265349575attach-table div div a {text-decoration:none;}#yiv7265349575 div.yiv7265349575attach-table {width:400px;}#yiv7265349575 div.yiv7265349575file-title a, #yiv7265349575 div.yiv7265349575file-title a:active, #yiv7265349575 div.yiv7265349575file-title a:hover, #yiv7265349575 div.yiv7265349575file-title a:visited {text-decoration:none;}#yiv7265349575 div.yiv7265349575photo-title a, #yiv7265349575 div.yiv7265349575photo-title a:active, #yiv7265349575 div.yiv7265349575photo-title a:hover, #yiv7265349575 div.yiv7265349575photo-title a:visited {text-decoration:none;}#yiv7265349575 div#yiv7265349575ygrp-mlmsg #yiv7265349575ygrp-msg p a span.yiv7265349575yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7265349575 .yiv7265349575green {color:#628c2a;}#yiv7265349575 .yiv7265349575MsoNormal {margin:0 0 0 0;}#yiv7265349575 o {font-size:0;}#yiv7265349575 #yiv7265349575photos div {float:left;width:72px;}#yiv7265349575 #yiv7265349575photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7265349575 #yiv7265349575photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7265349575 #yiv7265349575reco-category {font-size:77%;}#yiv7265349575 #yiv7265349575reco-desc {font-size:77%;}#yiv7265349575 .yiv7265349575replbq {margin:4px;}#yiv7265349575 #yiv7265349575ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7265349575 #yiv7265349575ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7265349575 #yiv7265349575ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7265349575 #yiv7265349575ygrp-mlmsg select, #yiv7265349575 input, #yiv7265349575 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7265349575 #yiv7265349575ygrp-mlmsg pre, #yiv7265349575 code {font:115% monospace;}#yiv7265349575 #yiv7265349575ygrp-mlmsg * {line-height:1.22em;}#yiv7265349575 #yiv7265349575ygrp-mlmsg #yiv7265349575logo {padding-bottom:10px;}#yiv7265349575 #yiv7265349575ygrp-msg p a {font-family:Verdana;}#yiv7265349575 #yiv7265349575ygrp-msg p#yiv7265349575attach-count span {color:#1E66AE;font-weight:700;}#yiv7265349575 #yiv7265349575ygrp-reco #yiv7265349575reco-head {color:#ff7900;font-weight:700;}#yiv7265349575 #yiv7265349575ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7265349575 #yiv7265349575ygrp-sponsor #yiv7265349575ov li a {font-size:130%;text-decoration:none;}#yiv7265349575 #yiv7265349575ygrp-sponsor #yiv7265349575ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7265349575 #yiv7265349575ygrp-sponsor #yiv7265349575ov ul {margin:0;padding:0 0 0 8px;}#yiv7265349575 #yiv7265349575ygrp-text {font-family:Georgia;}#yiv7265349575 #yiv7265349575ygrp-text p {margin:0 0 1em 0;}#yiv7265349575 #yiv7265349575ygrp-text tt {font-size:120%;}#yiv7265349575 #yiv7265349575ygrp-vital ul li:last-child {border-right:none !important;}#yiv7265349575  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Hitung Bonus Tambahan untuk Petugas Kring

ghozi alkatiri
 sory yang benar adalah:
=IF(MONTH(G2)=7,325000, IF(MONTH(G2)=6,400000, IF(MONTH(G2)=5,450000, IF(MONTH(G2)=4,500000,"zonk"))))

Ghozi Alkatiri
    Pada Kamis, 31 Oktober 2019 03.38.50 WIB, ghozi alkatiri [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

 mungkin rumus untuk J2  yang benar adalah =IF(G2=MONTH=7,325000, IF(G2=MONTH=6,400000, IF(G2=MONTH=5,450000, IF(G2=MONTH=4,500000,"zonk"))))


wassalam 
Ghozi Alkatiri    Pada Rabu, 30 Oktober 2019 22.38.14 WIB, Edhie Wibowo [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    
Selamat Siang semua rekan2,
mohon ijin utk bertanya ttg rumus IF bertingkat di kolom "I"
untuk memberikan uang bonus penghargaan kepada petugas Kring PBB.
Ketentuan bonus:
Untuk pelunasan bln Juli 2019 = Rp.325.000,-
Untuk pelunasan bln Juni 2019 = Rp.400.000,-
Untuk pelunasan bln Mei 2019 = Rp.450.000,-
Untuk pelunasan bln April 2019 = Rp.400.000,-

Saya coba memakai formula "IF" tapi kok error, mohon
pencerahannya.

Trims sebelumnya.

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

      #yiv2318001825 #yiv2318001825 -- #yiv2318001825ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2318001825 #yiv2318001825ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2318001825 #yiv2318001825ygrp-mkp #yiv2318001825hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2318001825 #yiv2318001825ygrp-mkp #yiv2318001825ads {margin-bottom:10px;}#yiv2318001825 #yiv2318001825ygrp-mkp .yiv2318001825ad {padding:0 0;}#yiv2318001825 #yiv2318001825ygrp-mkp .yiv2318001825ad p {margin:0;}#yiv2318001825 #yiv2318001825ygrp-mkp .yiv2318001825ad a {color:#0000ff;text-decoration:none;}#yiv2318001825 #yiv2318001825ygrp-sponsor #yiv2318001825ygrp-lc {font-family:Arial;}#yiv2318001825 #yiv2318001825ygrp-sponsor #yiv2318001825ygrp-lc #yiv2318001825hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2318001825 #yiv2318001825ygrp-sponsor #yiv2318001825ygrp-lc .yiv2318001825ad {margin-bottom:10px;padding:0 0;}#yiv2318001825 #yiv2318001825actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2318001825 #yiv2318001825activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2318001825 #yiv2318001825activity span {font-weight:700;}#yiv2318001825 #yiv2318001825activity span:first-child {text-transform:uppercase;}#yiv2318001825 #yiv2318001825activity span a {color:#5085b6;text-decoration:none;}#yiv2318001825 #yiv2318001825activity span span {color:#ff7900;}#yiv2318001825 #yiv2318001825activity span .yiv2318001825underline {text-decoration:underline;}#yiv2318001825 .yiv2318001825attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2318001825 .yiv2318001825attach div a {text-decoration:none;}#yiv2318001825 .yiv2318001825attach img {border:none;padding-right:5px;}#yiv2318001825 .yiv2318001825attach label {display:block;margin-bottom:5px;}#yiv2318001825 .yiv2318001825attach label a {text-decoration:none;}#yiv2318001825 blockquote {margin:0 0 0 4px;}#yiv2318001825 .yiv2318001825bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2318001825 .yiv2318001825bold a {text-decoration:none;}#yiv2318001825 dd.yiv2318001825last p a {font-family:Verdana;font-weight:700;}#yiv2318001825 dd.yiv2318001825last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2318001825 dd.yiv2318001825last p span.yiv2318001825yshortcuts {margin-right:0;}#yiv2318001825 div.yiv2318001825attach-table div div a {text-decoration:none;}#yiv2318001825 div.yiv2318001825attach-table {width:400px;}#yiv2318001825 div.yiv2318001825file-title a, #yiv2318001825 div.yiv2318001825file-title a:active, #yiv2318001825 div.yiv2318001825file-title a:hover, #yiv2318001825 div.yiv2318001825file-title a:visited {text-decoration:none;}#yiv2318001825 div.yiv2318001825photo-title a, #yiv2318001825 div.yiv2318001825photo-title a:active, #yiv2318001825 div.yiv2318001825photo-title a:hover, #yiv2318001825 div.yiv2318001825photo-title a:visited {text-decoration:none;}#yiv2318001825 div#yiv2318001825ygrp-mlmsg #yiv2318001825ygrp-msg p a span.yiv2318001825yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2318001825 .yiv2318001825green {color:#628c2a;}#yiv2318001825 .yiv2318001825MsoNormal {margin:0 0 0 0;}#yiv2318001825 o {font-size:0;}#yiv2318001825 #yiv2318001825photos div {float:left;width:72px;}#yiv2318001825 #yiv2318001825photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2318001825 #yiv2318001825photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2318001825 #yiv2318001825reco-category {font-size:77%;}#yiv2318001825 #yiv2318001825reco-desc {font-size:77%;}#yiv2318001825 .yiv2318001825replbq {margin:4px;}#yiv2318001825 #yiv2318001825ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2318001825 #yiv2318001825ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2318001825 #yiv2318001825ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2318001825 #yiv2318001825ygrp-mlmsg select, #yiv2318001825 input, #yiv2318001825 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2318001825 #yiv2318001825ygrp-mlmsg pre, #yiv2318001825 code {font:115% monospace;}#yiv2318001825 #yiv2318001825ygrp-mlmsg * {line-height:1.22em;}#yiv2318001825 #yiv2318001825ygrp-mlmsg #yiv2318001825logo {padding-bottom:10px;}#yiv2318001825 #yiv2318001825ygrp-msg p a {font-family:Verdana;}#yiv2318001825 #yiv2318001825ygrp-msg p#yiv2318001825attach-count span {color:#1E66AE;font-weight:700;}#yiv2318001825 #yiv2318001825ygrp-reco #yiv2318001825reco-head {color:#ff7900;font-weight:700;}#yiv2318001825 #yiv2318001825ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2318001825 #yiv2318001825ygrp-sponsor #yiv2318001825ov li a {font-size:130%;text-decoration:none;}#yiv2318001825 #yiv2318001825ygrp-sponsor #yiv2318001825ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2318001825 #yiv2318001825ygrp-sponsor #yiv2318001825ov ul {margin:0;padding:0 0 0 8px;}#yiv2318001825 #yiv2318001825ygrp-text {font-family:Georgia;}#yiv2318001825 #yiv2318001825ygrp-text p {margin:0 0 1em 0;}#yiv2318001825 #yiv2318001825ygrp-text tt {font-size:120%;}#yiv2318001825 #yiv2318001825ygrp-vital ul li:last-child {border-right:none !important;}#yiv2318001825  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Hitung Bonus Tambahan untuk Petugas Kring

ghozi alkatiri
 atau kalau mau lebih sederhana dengan hasil yang sama tulis di J2
=IFERROR(INDEX({500000,450000,400000,325000},MONTH(G2)-3),"zonk")

Ghozi Alkatiri


    Pada Kamis, 31 Oktober 2019 05.23.19 WIB, ghozi alkatiri [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

 sory yang benar adalah:
=IF(MONTH(G2)=7,325000, IF(MONTH(G2)=6,400000, IF(MONTH(G2)=5,450000, IF(MONTH(G2)=4,500000,"zonk"))))

Ghozi Alkatiri
    Pada Kamis, 31 Oktober 2019 03.38.50 WIB, ghozi alkatiri [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

 mungkin rumus untuk J2  yang benar adalah =IF(G2=MONTH=7,325000, IF(G2=MONTH=6,400000, IF(G2=MONTH=5,450000, IF(G2=MONTH=4,500000,"zonk"))))


wassalam 
Ghozi Alkatiri    Pada Rabu, 30 Oktober 2019 22.38.14 WIB, Edhie Wibowo [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    
Selamat Siang semua rekan2,
mohon ijin utk bertanya ttg rumus IF bertingkat di kolom "I"
untuk memberikan uang bonus penghargaan kepada petugas Kring PBB.
Ketentuan bonus:
Untuk pelunasan bln Juli 2019 = Rp.325.000,-
Untuk pelunasan bln Juni 2019 = Rp.400.000,-
Untuk pelunasan bln Mei 2019 = Rp.450.000,-
Untuk pelunasan bln April 2019 = Rp.400.000,-

Saya coba memakai formula "IF" tapi kok error, mohon
pencerahannya.

Trims sebelumnya.

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

          #yiv6224570014 #yiv6224570014 -- #yiv6224570014ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6224570014 #yiv6224570014ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6224570014 #yiv6224570014ygrp-mkp #yiv6224570014hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6224570014 #yiv6224570014ygrp-mkp #yiv6224570014ads {margin-bottom:10px;}#yiv6224570014 #yiv6224570014ygrp-mkp .yiv6224570014ad {padding:0 0;}#yiv6224570014 #yiv6224570014ygrp-mkp .yiv6224570014ad p {margin:0;}#yiv6224570014 #yiv6224570014ygrp-mkp .yiv6224570014ad a {color:#0000ff;text-decoration:none;}#yiv6224570014 #yiv6224570014ygrp-sponsor #yiv6224570014ygrp-lc {font-family:Arial;}#yiv6224570014 #yiv6224570014ygrp-sponsor #yiv6224570014ygrp-lc #yiv6224570014hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6224570014 #yiv6224570014ygrp-sponsor #yiv6224570014ygrp-lc .yiv6224570014ad {margin-bottom:10px;padding:0 0;}#yiv6224570014 #yiv6224570014actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6224570014 #yiv6224570014activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6224570014 #yiv6224570014activity span {font-weight:700;}#yiv6224570014 #yiv6224570014activity span:first-child {text-transform:uppercase;}#yiv6224570014 #yiv6224570014activity span a {color:#5085b6;text-decoration:none;}#yiv6224570014 #yiv6224570014activity span span {color:#ff7900;}#yiv6224570014 #yiv6224570014activity span .yiv6224570014underline {text-decoration:underline;}#yiv6224570014 .yiv6224570014attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6224570014 .yiv6224570014attach div a {text-decoration:none;}#yiv6224570014 .yiv6224570014attach img {border:none;padding-right:5px;}#yiv6224570014 .yiv6224570014attach label {display:block;margin-bottom:5px;}#yiv6224570014 .yiv6224570014attach label a {text-decoration:none;}#yiv6224570014 blockquote {margin:0 0 0 4px;}#yiv6224570014 .yiv6224570014bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6224570014 .yiv6224570014bold a {text-decoration:none;}#yiv6224570014 dd.yiv6224570014last p a {font-family:Verdana;font-weight:700;}#yiv6224570014 dd.yiv6224570014last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6224570014 dd.yiv6224570014last p span..yiv6224570014yshortcuts {margin-right:0;}#yiv6224570014 div.yiv6224570014attach-table div div a {text-decoration:none;}#yiv6224570014 div.yiv6224570014attach-table {width:400px;}#yiv6224570014 div.yiv6224570014file-title a, #yiv6224570014 div.yiv6224570014file-title a:active, #yiv6224570014 div.yiv6224570014file-title a:hover, #yiv6224570014 div.yiv6224570014file-title a:visited {text-decoration:none;}#yiv6224570014 div.yiv6224570014photo-title a, #yiv6224570014 div.yiv6224570014photo-title a:active, #yiv6224570014 div..yiv6224570014photo-title a:hover, #yiv6224570014 div.yiv6224570014photo-title a:visited {text-decoration:none;}#yiv6224570014 div#yiv6224570014ygrp-mlmsg #yiv6224570014ygrp-msg p a span.yiv6224570014yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6224570014 .yiv6224570014green {color:#628c2a;}#yiv6224570014 .yiv6224570014MsoNormal {margin:0 0 0 0;}#yiv6224570014 o {font-size:0;}#yiv6224570014 #yiv6224570014photos div {float:left;width:72px;}#yiv6224570014 #yiv6224570014photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6224570014 #yiv6224570014photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6224570014 #yiv6224570014reco-category {font-size:77%;}#yiv6224570014 #yiv6224570014reco-desc {font-size:77%;}#yiv6224570014 .yiv6224570014replbq {margin:4px;}#yiv6224570014 #yiv6224570014ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6224570014 #yiv6224570014ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6224570014 #yiv6224570014ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6224570014 #yiv6224570014ygrp-mlmsg select, #yiv6224570014 input, #yiv6224570014 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6224570014 #yiv6224570014ygrp-mlmsg pre, #yiv6224570014 code {font:115% monospace;}#yiv6224570014 #yiv6224570014ygrp-mlmsg * {line-height:1.22em;}#yiv6224570014 #yiv6224570014ygrp-mlmsg #yiv6224570014logo {padding-bottom:10px;}#yiv6224570014 #yiv6224570014ygrp-msg p a {font-family:Verdana;}#yiv6224570014 #yiv6224570014ygrp-msg p#yiv6224570014attach-count span {color:#1E66AE;font-weight:700;}#yiv6224570014 #yiv6224570014ygrp-reco #yiv6224570014reco-head {color:#ff7900;font-weight:700;}#yiv6224570014 #yiv6224570014ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6224570014 #yiv6224570014ygrp-sponsor #yiv6224570014ov li a {font-size:130%;text-decoration:none;}#yiv6224570014 #yiv6224570014ygrp-sponsor #yiv6224570014ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6224570014 #yiv6224570014ygrp-sponsor #yiv6224570014ov ul {margin:0;padding:0 0 0 8px;}#yiv6224570014 #yiv6224570014ygrp-text {font-family:Georgia;}#yiv6224570014 #yiv6224570014ygrp-text p {margin:0 0 1em 0;}#yiv6224570014 #yiv6224570014ygrp-text tt {font-size:120%;}#yiv6224570014 #yiv6224570014ygrp-vital ul li:last-child {border-right:none !important;}#yiv6224570014  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Hitung Bonus Tambahan untuk Petugas Kring

Edhie Wibowo
In reply to this post by Edhie Wibowo
Pagi mas Ghozi dan temen2, untuk rumus yg disarankan mas, ini saya
coba kok blm bisa, mohon pencerahannya. (saya sertakan file utk
dianalisa). Terima kasih
---------------------------------------------------------------------------------------------
Rumus yg disarankan:
mungkin rumus untuk J2  yang benar adalah
=IF(G2=MONTH=7,325000, IF(G2=MONTH=6,400000, IF(G2=MONTH=5,450000,
IF(G2=MONTH=4,500000,"zonk"))))
---------------------------------------------------------------------------------------------
--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Hitung Bonus Tambahan untuk Petugas Kring [1 Attachment]

Edhie Wibowo
In reply to this post by Edhie Wibowo
Pagi mas Ghozi dan temen2, untuk rumus yg disarankan mas, ini saya
coba kok blm bisa, mohon pencerahannya. (saya sertakan file utk
dianalisa). Terima kasih
---------------------------------------------------------------------------------------------
Rumus yg disarankan:
mungkin rumus untuk J2  yang benar adalah
=IF(G2=MONTH=7,325000, IF(G2=MONTH=6,400000, IF(G2=MONTH=5,450000,
IF(G2=MONTH=4,500000,"zonk"))))
---------------------------------------------------------------------------------------------

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

rumus hitung bonus.xlsx (12K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Hitung Bonus Tambahan untuk Petugas Kring

Edhie Wibowo
In reply to this post by Edhie Wibowo
Makasih banyak mas Ghozi, skr sdh benar rumusnya. :)

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Hitung Bonus Tambahan untuk Petugas Kring

ghozi alkatiri
In reply to this post by Edhie Wibowo
 selamat pagi,kan sudah saya ralat , yang betul adalah di J2 copy ke bawah
=IF(MONTH(G2)=7,325000, IF(MONTH(G2)=6,400000, IF(MONTH(G2)=5,450000, IF(MONTH(G2)=4,500000,"zonk"))))


atau yang lebih sederhana
=IFERROR(INDEX({500000,450000,400000,325000},MONTH(G2)-3),"zonk")

silahkan dicoba dua duanya saya tunggu responnya
wassalam


    Pada Kamis, 31 Oktober 2019 06.21.41 WIB, Edhie Wibowo [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    
Pagi mas Ghozi dan temen2, untuk rumus yg disarankan mas, ini saya
coba kok blm bisa, mohon pencerahannya. (saya sertakan file utk
dianalisa). Terima kasih
----------------------------------------------------------
Rumus yg disarankan:
mungkin rumus untuk J2 yang benar adalah
=IF(G2=MONTH=7,325000, IF(G2=MONTH=6,400000, IF(G2=MONTH=5,450000,
IF(G2=MONTH=4,500000,"zonk"))))
----------------------------------------------------------

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

  #yiv6343239071 #yiv6343239071 -- #yiv6343239071ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6343239071 #yiv6343239071ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6343239071 #yiv6343239071ygrp-mkp #yiv6343239071hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6343239071 #yiv6343239071ygrp-mkp #yiv6343239071ads {margin-bottom:10px;}#yiv6343239071 #yiv6343239071ygrp-mkp .yiv6343239071ad {padding:0 0;}#yiv6343239071 #yiv6343239071ygrp-mkp .yiv6343239071ad p {margin:0;}#yiv6343239071 #yiv6343239071ygrp-mkp .yiv6343239071ad a {color:#0000ff;text-decoration:none;}#yiv6343239071 #yiv6343239071ygrp-sponsor #yiv6343239071ygrp-lc {font-family:Arial;}#yiv6343239071 #yiv6343239071ygrp-sponsor #yiv6343239071ygrp-lc #yiv6343239071hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6343239071 #yiv6343239071ygrp-sponsor #yiv6343239071ygrp-lc .yiv6343239071ad {margin-bottom:10px;padding:0 0;}#yiv6343239071 #yiv6343239071actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6343239071 #yiv6343239071activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6343239071 #yiv6343239071activity span {font-weight:700;}#yiv6343239071 #yiv6343239071activity span:first-child {text-transform:uppercase;}#yiv6343239071 #yiv6343239071activity span a {color:#5085b6;text-decoration:none;}#yiv6343239071 #yiv6343239071activity span span {color:#ff7900;}#yiv6343239071 #yiv6343239071activity span .yiv6343239071underline {text-decoration:underline;}#yiv6343239071 .yiv6343239071attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6343239071 .yiv6343239071attach div a {text-decoration:none;}#yiv6343239071 .yiv6343239071attach img {border:none;padding-right:5px;}#yiv6343239071 .yiv6343239071attach label {display:block;margin-bottom:5px;}#yiv6343239071 .yiv6343239071attach label a {text-decoration:none;}#yiv6343239071 blockquote {margin:0 0 0 4px;}#yiv6343239071 .yiv6343239071bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6343239071 .yiv6343239071bold a {text-decoration:none;}#yiv6343239071 dd.yiv6343239071last p a {font-family:Verdana;font-weight:700;}#yiv6343239071 dd.yiv6343239071last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6343239071 dd.yiv6343239071last p span.yiv6343239071yshortcuts {margin-right:0;}#yiv6343239071 div.yiv6343239071attach-table div div a {text-decoration:none;}#yiv6343239071 div.yiv6343239071attach-table {width:400px;}#yiv6343239071 div.yiv6343239071file-title a, #yiv6343239071 div.yiv6343239071file-title a:active, #yiv6343239071 div.yiv6343239071file-title a:hover, #yiv6343239071 div.yiv6343239071file-title a:visited {text-decoration:none;}#yiv6343239071 div.yiv6343239071photo-title a, #yiv6343239071 div.yiv6343239071photo-title a:active, #yiv6343239071 div.yiv6343239071photo-title a:hover, #yiv6343239071 div.yiv6343239071photo-title a:visited {text-decoration:none;}#yiv6343239071 div#yiv6343239071ygrp-mlmsg #yiv6343239071ygrp-msg p a span.yiv6343239071yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6343239071 .yiv6343239071green {color:#628c2a;}#yiv6343239071 .yiv6343239071MsoNormal {margin:0 0 0 0;}#yiv6343239071 o {font-size:0;}#yiv6343239071 #yiv6343239071photos div {float:left;width:72px;}#yiv6343239071 #yiv6343239071photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6343239071 #yiv6343239071photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6343239071 #yiv6343239071reco-category {font-size:77%;}#yiv6343239071 #yiv6343239071reco-desc {font-size:77%;}#yiv6343239071 .yiv6343239071replbq {margin:4px;}#yiv6343239071 #yiv6343239071ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6343239071 #yiv6343239071ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6343239071 #yiv6343239071ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6343239071 #yiv6343239071ygrp-mlmsg select, #yiv6343239071 input, #yiv6343239071 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6343239071 #yiv6343239071ygrp-mlmsg pre, #yiv6343239071 code {font:115% monospace;}#yiv6343239071 #yiv6343239071ygrp-mlmsg * {line-height:1.22em;}#yiv6343239071 #yiv6343239071ygrp-mlmsg #yiv6343239071logo {padding-bottom:10px;}#yiv6343239071 #yiv6343239071ygrp-msg p a {font-family:Verdana;}#yiv6343239071 #yiv6343239071ygrp-msg p#yiv6343239071attach-count span {color:#1E66AE;font-weight:700;}#yiv6343239071 #yiv6343239071ygrp-reco #yiv6343239071reco-head {color:#ff7900;font-weight:700;}#yiv6343239071 #yiv6343239071ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6343239071 #yiv6343239071ygrp-sponsor #yiv6343239071ov li a {font-size:130%;text-decoration:none;}#yiv6343239071 #yiv6343239071ygrp-sponsor #yiv6343239071ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6343239071 #yiv6343239071ygrp-sponsor #yiv6343239071ov ul {margin:0;padding:0 0 0 8px;}#yiv6343239071 #yiv6343239071ygrp-text {font-family:Georgia;}#yiv6343239071 #yiv6343239071ygrp-text p {margin:0 0 1em 0;}#yiv6343239071 #yiv6343239071ygrp-text tt {font-size:120%;}#yiv6343239071 #yiv6343239071ygrp-vital ul li:last-child {border-right:none !important;}#yiv6343239071