Dear Lazuardi,

bisa coba fungsi absolute untuk menghitung nilai positif dan mengembalikan ke 
sifat semula (positif/negatif).
=MOD(ABS(I3),D3)*I3/ABS(I3)

blessings,
tomz

From: Lazuardi Biru 
Sent: Tuesday, March 19, 2013 12:14 PM
To: [email protected] 
Subject: ]] XL-mania [[ cara menggunakan fungsi MOD

  

tolong dibantu para master
file terlampir






salam






lazuardi

Kirim email ke