Coba tambhakan fungsi If pada sel K3, menjadi: =IFERROR(MOD(IF(I$3:I$129<0,I$3:I$129*-1,I$3:I$129),D$3:D$129),"")
kemudian copy ke bawah. Salam, HK ________________________________ From: Lazuardi Biru <[email protected]> To: "[email protected]" <[email protected]> Sent: Tuesday, 19 March 2013, 12:14 Subject: ]] XL-mania [[ cara menggunakan fungsi MOD tolong dibantu para master file terlampir salam lazuardi
