Thread: Logical Test if statements with text--Excel 2002

huh?
>>be returned to be whatever letter it was
--
Don Guillett
SalesAid Software
donaldb@281.com
"Matt" <Matt@discussions.microsoft.com> wrote in message
news:B0223028-7A92-4506-A369-C8D248897D65@microsoft.com...
> 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?

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?

huh?
>>be returned to be whatever letter it was
--
Don Guillett
SalesAid Software
donaldb@281.com
"Matt" <Matt@discussions.microsoft.com> wrote in message
news:B0223028-7A92-4506-A369-C8D248897D65@microsoft.com...
> 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?

One way, if I understand you correctly:


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


In article <B0223028-7A92-4506-A369-C8D248897D65@microsoft.com>,
"Matt" <Matt@discussions.microsoft.com> 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?