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]>

> **
>
>
>  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
>
>  
>

Kirim email ke