Wah...mantap...

Terimakasih banyak Mr. Kid..

Bisa dijelasin gak cara baca rumusnya?

Maklum... J



Rgds,

Febri



From: [email protected] [mailto:[email protected]] On 
Behalf Of Mr. Kid
Sent: 09 Desember 2012 19:51
To: [email protected]
Subject: Re: [belajar-excel] Deadline





Pak Febri,

Coba :
1. hasilnya bertipe numerik kemudian di format cell :
=E4-LOOKUP(9^9,A4:D4)
kemudian atur format cells -> tab number -> custom -> tulis :
"> Dead Line";"< Dead Line";"= Dead Line"
lalu, copy ke baris lain

2. hasilnya bertipe teks
=LOOKUP(E4-LOOKUP(9^9,A4:D4),{-999999,0,1},{"<","=",">"}) & " Dead Line"

Wassalam,
Kid.

2012/12/8 Wahyudi Febrian 
<[email protected]<mailto:[email protected]>>



Dear All Master,

Mohon bantuannya untuk rumus permasalahan terlampir.

Ditunggu slalu advicenya.. J



Rgds,

Febri



__________ Information from ESET NOD32 Antivirus, version of virus signature 
database 7710 (20121120) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com







__________ Information from ESET NOD32 Antivirus, version of virus signature 
database 7710 (20121120) __________



The message was checked by ESET NOD32 Antivirus.



http://www.eset.com

Kirim email ke