"IF" Function

  • Thread starter Thread starter Annelin
  • Start date Start date
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
 
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
Excel formula, sum the value cell and if empty cell left blank 0
Using text in a cell in a formula 2
Excel VBA 1
Function to determine if a cell contains a formula 5
Ignore blank celss in left function 2
Formula vs. Constant 24
Functions 1

Back
Top