=A6-SUBSTITUTE(SUBSTITUTE(B6,",",""),CHAR(160),"")
atau lebih fleksibel *=A6-TRIM(SUBSTITUTE(SUBSTITUTE(B6,",",""),CHAR(160),""))* * * *On Tue, Mar 20, 2012 at 4:48 PM, Mansor <[email protected]> wrote: > Para teman BeExcel, > Gimana caranya melakukan kalkulasi ke atas > angka di kolum A yg formatnya Number dengan > angka di kolum B yang formatnya TEXT, tanpa perlu > pake dummy. > Terima kasih > -Mansor* * * > * * ISNUMBER ISNUMBER FORMAT NUMBER FORMAT TEXT Dummy Hasil > yang diingikan jika Kolum A - Kolum B tanpa dummy TRUE FALSE > 139,143.71 132,349.21 132,349.21 > 6,794.50 >
