Coba dengan menggabungkan formulanya seperti ini : =SUM(A6-IF(B6<>"",VALUE(SUBSTITUTE(SUBSTITUTE(B6,",",""),CHAR(160),"")),"")) (Huruf tebal diambil dari formula di sel C6).
Copy ke bawah. Salam, Hendrik Karnadi ________________________________ From: Mansor <[email protected]> To: belajar-excel <[email protected]> Sent: Tuesday, 20 March 2012, 16:48 Subject: [belajar-excel] Kalkulasi 2 angka yang berbeda format Para teman BeExcel, Gimana caranyamelakukan 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 469,676.58 443,396.19 443,396.19 26,280.39 829,722.61 793,598.64 793,598.64 36,123.97 422,774.05 404,869.97 404,869.97 17,904.08 134,003.46 125,230.43 125,230.43 8,773.03 277,595.84 263,221.59 263,221.59 14,374.25 389,018.28 364,653.41 364,653.41 24,364.87 249,650.93 234,358.41 234,358.41 15,292.52 260,122.33 244,670.00 244,670.00 15,452.33 149,923.46 141,486.23 141,486.23 8,437.23 52,302.72 49,841.61 49,841.61 2,461.11
