Use the double quotes for text string

IF(A1="annelin",TRUE,FALSE)

OR

IF(A1="annelin",A1,"")

If this post helps click Yes
---------------
Jacob Skaria


"Annelin" wrote:

I would like to use the above function to return a value however the cell
used in the logical part of the formula contains text.

Is there away around this cell not having a value or is there another
formula that will return a value from an adjacent cell based on text?

I am using Excel 2003.

Thanks