bisa, tapi jangan pake rumus round, karena round hanya membulatkan ke nilai
bulat ke atas atau ke bawah
misal 10, 100, 1000, dst
kalau mau pakai rumus kombinasi antara fungsi if dan fungsi and
contoh:
=IF(AND(A1>500,A1<550),550,600)
----- Original Message -----
From: "Sanddy" <[EMAIL PROTECTED]>
To: <itcenter@yahoogroups.com>
Sent: Friday, March 25, 2005 4:50 AM
Subject: [ITCENTER] Tanya rumus di MS EXCEL lagi
>
>
> Saya mau tanya rumus di MS EXCEL lagi.
> Di row A1 s/d A8 saya isi dengan angka: 501, 525, 530, 549, 550, 551, 573,
> 598.
> Dengan rumus =ROUND(A1,-2) s/d =ROUND(A8,-2), row B1 s/d B8 menjadi terisi
> : 500, 500, 500, 500, 600, 600, 600, 600.
> Yang saya ingin tanyakan bisakah rumus tsb. dimodifikasi agar hasil nilai
> 600 tsb. bisa menjadi nilai 550? Dengan kata lain hanya ada 2 nilai yakni
> 500 atau 550? Bisakah?
> Terima kasih.
>
> Sanddy
>
>
> [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 ##
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> --
> Internal Virus Database is out-of-date.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 266.8.0 - Release Date: 21/03/2005
>
>
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.8.4 - Release Date: 27/03/2005
--
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 ##
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/
