Mainan Excel Yuk... [ SHARE, DISKUSI, ASK, TUTORIAL, ALL ABOUT EXCEL BASIC ]
numpang nanya gan... untuk rumusnya di tulisan warna merah, mksh https://s.kaskus.id/images/2018/06/08/673580_20180608094357.jpg soal 1 ==(ROUNDDOWN(B2/2;0)*3000)+((B2-(ROUNDDOWN(B2/2;0)*2))*1000) soal 2 =IF((A2)-ROUNDDOWN(A2;0)>0;"terdapat koma";"TRUE")