walalupun bukan penanya, boleh kamplain ya ?
Kok hasilnya spt ini ya ?? (Kuning: formula dari sugik, Birumuda: hasil yg diinginkan)
|
| UN | NS | NA |
| UN | NS | NA |
|
|
| Peserta | 60% | 40% |
|
| 60% | 40% |
|
| samakah? |
| Siti Fadillah | 5.80 | 7.90 | 6.64 |
| 5.80 | 7.90 | 6.6 |
| FALSE |
| Uningsih | 5.40 | 8.03 | 6.45 |
| 5.40 | 8.03 | 6.5 |
| FALSE |
| Umay | 6.60 | 8.10 | 7.20 |
| 6.60 | 8.10 | 7.2 |
| FALSE |
| Rosita | 5.00 | 8.00 | 6.20 |
| 5.00 | 8.00 | 6.2 |
| TRUE |
| Agustinus | 7.40 | 8.59 | 7.88 |
| 7.40 | 8.59 | 7.9 |
| FALSE |
| Maman | 7.40 | 8.77 | 7.95 |
| 7.40 | 8.77 | 8.0 |
| FALSE |
| Dadang | 7.20 | 7.82 | 7.45 |
| 7.20 | 7.82 | 7.5 |
| FALSE |
| Sarta | 7.00 | 7.87 | 7.35 |
| 7.00 | 7.87 | 7.4 |
| FALSE |
| Sinta | 6.20 | 8.32 | 7.05 |
| 6.20 | 8.32 | 7.1 |
| FALSE |
| Kamal | 6.20 | 7.82 | 6.85 |
| 6.20 | 7.82 | 6.9 |
| FALSE |
| Edi | 6.00 | 7.87 | 6.75 |
| 6.00 | 7.87 | 6.8 |
| FALSE |
2011/6/10 Sugiantara, Komang <Komang.Sugiantara@unilever.com>
dear annur,pakai fungsi ROUND ya ...=ROUND((B28*$B$17)+(C28*$C$17),2)semoga membantu.Rgds,Sugik
From: XL-mania@yahoogroups.com On Behalf Of Abc D
Sent: Friday, June 10, 2011 9:49 AMSubject: ]] XL-mania [[ Penjumlahan yang di inginkanKepada Yth Master Exceldi TempatSaya kesulitan dalam menjumlahakan, hasil UN, Mohon pencerhannya dan saya lampirkan contohnya.mohon maaf kalau ada kata yang kurang berkenan.wasalamannur
__._,_.___
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| maaf baru moderate sekarang... momods kurang tidur berhari-hari |
| jadi budak kantoooOOooorrr... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
| maaf baru moderate sekarang... momods kurang tidur berhari-hari |
| jadi budak kantoooOOooorrr... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
MARKETPLACE
.
__,_._,___
Nenhum comentário:
Postar um comentário