If function with range and two criteria

[moding blaine]

I have the following formula below to return "C" if the value in the cell is "C", and nothing if not.

I want to expand it to return "C" if the value in the cell is "C" or "D", for a range between C2:H2.


=IF(C2="C","C","")

I'm have trouble with this easy adjustment.

[NBVC]

This formula returns "C" if a "C" is found and a "D" if a "D" is found... it posts whichever it finds first, if both letters exist in the range:

=IF(COUNTIF(C2:H2,"C"),"C",IF(COUNTIF(C2:H2,"D"),"D",""))

is that what you needed?

[moding blaine]

Thanks for your help!

[NBVC]

You are welcome... actually, just a correction in my statement:

it posts whichever it finds first, if both letters exist in the range:

That is not true; it will post a "C" if a "C" exists, whether it is before or after any "D" in the range... it will only post a "D" if that is the only letter matching... (i.e. no "C" in the range at all)....

Just wanted to clarify that in case you expected the results I had described.