KolomE3 =IF(D3="I",1750000,IF(D3="II",2250000,IF(D3="III",3000000,IF(D3="IV",4000000))))
KolomI3 =G3*H3
KolomJ3 =IF(AND(I3>500000,I3<1500000),"10%",IF(I3>=1500000,"20%","0"))
KolomK3 =((I3*J3)+I3)-F3
KolomL3 =IF(OR(H3>=50000,G3>5),"Dapat","Tidak Dapat")
KolomM3
KolomI3 =G3*H3
KolomJ3 =IF(AND(I3>500000,I3<1500000),"10%",IF(I3>=1500000,"20%","0"))
KolomK3 =((I3*J3)+I3)-F3
KolomL3 =IF(OR(H3>=50000,G3>5),"Dapat","Tidak Dapat")
KolomM3
0 Response to "formula untuk tugas X OR"
Posting Komentar