Dear Jimmy,
=IF(RIGHT(D2,2)="cr",-1*(MID(D2,1,FIND("c",D2)-2)),D2) tadinya
=IF(RIGHT(D2,2)="cr",-1*(MID(D2,1,FIND("c",D2)-1)),D2) => cr itu 2________________________________ From: jimmy sihombing <[email protected]> To: XL-mania <[email protected]> Sent: Wednesday, May 15, 2013 11:37 AM Subject: ]] XL-mania [[ text ubah ke number Hallo Dear All Master, Saya punya kasus (file terlampir). Thanks, JHE
