101.22 - 100.21 = 1.01 (formula result) tapi kalo cell ini di-paste special dengan mengambil nilai value, maka hasilnya jadi 1.01000001 itu sebabnya gak sama dengan 1.01 (FALSE)
Nah mengapa bisa jadi 1.01000001 itu saya juga gak tau :D Bug? Easter egg? On 6/24/05, Abimono <[EMAIL PROTECTED]> wrote: > tulis 1.01 di A1 > tulis 1.01 di A2 > tulis =A1=A2 di A3 > > hasilnya TRUE kan? > > sekarang coba lagi > tulis 101.22 di A1 > tulis 100.21 di A2 > tulis =A1-A2 di A3 > tulis 1.01 di A4 > tulis =A3=A4 di A5 > > lihat hasilnya > > ________________________________ > > From: ITCENTER@yahoogroups.com on behalf of Setyo Suhartanto > Sent: Fri 6/24/2005 3:16 PM > To: ITCENTER@yahoogroups.com > Subject: Re: [ITCENTER] excel > > > > Gak bisa attachment > > On 6/24/05, Abimono <[EMAIL PROTECTED]> wrote: > > ada yang sering pakai excel ga di sini? > > bisa jelasin ga kenapa terjadi kayak gini? [lihat attachment] > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > -- > > www.ITCENTER.or.id - Komunitas Teknologi Informasi Indonesia > > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > > ::: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::: > > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > > > :: Sponsor ----------------------------------------------- > > Web hosting 1GB space cuma Rp. 65ribu/bln > > Multiple website, free domain name. http://www.rakdata.com > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > -- > www.ITCENTER.or.id - Komunitas Teknologi Informasi Indonesia > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > ::: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::: > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > :: Sponsor ----------------------------------------------- > Web hosting 1GB space cuma Rp. 65ribu/bln > Multiple website, free domain name. http://www.rakdata.com > > > Yahoo! Groups Links > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > -- > www.ITCENTER.or.id - Komunitas Teknologi Informasi Indonesia > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > ::: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::: > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > :: Sponsor ----------------------------------------------- > Web hosting 1GB space cuma Rp. 65ribu/bln > Multiple website, free domain name. http://www.rakdata.com > > > Yahoo! Groups Links > > > > > > > -- www.ITCENTER.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ::: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ :: Sponsor ----------------------------------------------- Web hosting 1GB space cuma Rp. 65ribu/bln Multiple website, free domain name. http://www.rakdata.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/