=IF(C1=MAX(C:C),"Expensive","Cheap")

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"thanhnguyen"
wrote in message
...

Hi Bob

If value of cell in Coloumn C is max, displayed "Expensive" in column E
and else is "Cheap"

Thanks.


--
thanhnguyen
------------------------------------------------------------------------
thanhnguyen's Profile:
http://www.excelforum.com/member.php...o&userid=30502
View this thread: http://www.excelforum.com/showthread...hreadid=544941