Hi Nguyen,

It should be numeric not text. If you look at my original formula, you will
see I anticipated this

=--MID(A1,FIND("*",A1)+1,FIND("*(",A1)-FIND("*",A1)-1)

the -- changes the text to numbers.

Check that the column is formatted as General, not text.


--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"thanhnguyen"
wrote in message
...

Hi Bob,

Max("C:C")=0 because of after using MID function it return text not
number,

and I would like to display Expensive or Cheap only on cell which is
max and min not all.

Thanks so much,

Thanh Nguyen


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