Re: ]] XL-mania [[ OK atau LEWAT

 

diinginkan	dijawab
Contoh Status	STATUS
ok	OK
lewat	LEWAT
ok	LEWAT
lewat	LEWAT
ok	LEWAT
EXTRA TES	OK
EXTRA TES	LEWAT

 

hasilnya kok ndak sama dengan yg diinginkan yach....

 

---

----- Original Message -----

From: yudo sasono

To: XL-mania@yahoogroups.com

Sent: Friday, April 16, 2010 4:50 PM

Subject: Re: ]] XL-mania [[ OK atau LEWAT

Saya buat formula macam ini: =IF(AND(E4=1,F4<=600),"OK","LEWAT")

hasilnya:

No. AHASS	No. Mesin	No. Buku	Tgl. Beli	Service ke	Kilometer	Tgl. Service	Contoh Status	STATUS
08800	JBC2E1194105	HA0439445	11122009	1	491	31122009	ok	OK
10127	MC22E1048866	HA0057041	08122009	1	700	19122009	lewat	LEWAT
01933	HB61E1599614	GA0205877	01102009	2	1920	30122009	ok	LEWAT
06931	JF13E0019399	HB0051211	04092009	2	2500	31122009	lewat	LEWAT
06667	JF12E1754381	HB0005485	02072009	4	5689	05122009	ok	LEWAT
EXTRA TES	EXTRA TES	EXTRA TES	EXTRA TES	1	600	EXTRA TES	EXTRA TES	OK
EXTRA TES	EXTRA TES	EXTRA TES	EXTRA TES	2	600	EXTRA TES	EXTRA TES	LEWAT

atau lihat di attachment..
btw, ada 2 baris tes limit yg saya buat.

 

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 77

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Momods kebanyak meeting :( :( :(                                  |
| 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

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

---

Welcome to Mom Connection! Share stories, news and more with moms like you.

---

Hobbies & Activities Zone: Find others who share your passions! Explore new interests.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___