Logical Test if statements with text--Excel 2002
One way, if I understand you correctly:
=IF(SUM(COUNTIF(A1,{"r","y","g","c"}))0,A1,"")
In article ,
"Matt" wrote:
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?
|