Logical Test if statements with text--Excel 2002

G

Guest

I am trying to format a cell to check and see values for a range of other
cells. If the value of the cell is a text letter (r, y, g, or c) I want the
value to be returned to be whatever letter it was. How can I do thies?
 
J

JE McGimpsey

One way, if I understand you correctly:


=IF(SUM(COUNTIF(A1,{"r","y","g","c"}))>0,A1,"")
 

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

Test cells for values if date matches 1
Test cells for values if date matches 1
Logical Test Question 2
Logical Test for a value in a named list? 10
IF need to add a third value 6
Conditional formatting in Excel 2010 2
Logical Test on Date value 1
if statement with vlookup 1

Top