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