"IF" Function

A

Annelin

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
 
J

Jacob Skaria

Use the double quotes for text string

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

OR

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Function to determine if a cell contains a formula 5
Formula vs. Constant 24
Dragging with IF-Functions 1
Excel VBA 1
ISLOGICAL function 7
Using text in a cell in a formula 2
Text to Formula 3

Top