Thank you, but the formula doesn't give me the correct result. If I have
either "T" or "R" in all the cells, it gives me a "Fail" result, when I need
a "Pass" result.
--
Michelle


"T. Valko" wrote:

OK, just need a slight modification:

=IF(SUM(COUNTIF(A1:A10,{"R","T"}))=ROWS(A1:A10),"P ass","Fail")


--
Biff
Microsoft Excel MVP


"Michelle" wrote in message
...
Thank you for your replies, but I obviously didn't make myself clear. Am
trying to create a formula whe if the range of cells has the letter
"R"
or "T" in the cells, then the result will be "pass", but if any cell is
blank
or has a different letter in it, then the result will be "fail".

Thanks,

--
Michelle


"T. Valko" wrote:

I'm assuming you mean if *any* cell in the range contains a R or T.

Assume the range in question is A1:A10...

=IF(SUM(COUNTIF(A1:A10,{"R","T"})),"Pass","Fail")

If *every* cell in the range is empty the result of the formula will be
Fail. Don't know if that's what you want.

--
Biff
Microsoft Excel MVP


"Michelle" wrote in message
...
Am trying to create a formula that will tell me: if the range of cells
has
the single letter "R" or the single letter "T" in the individuals
cells,
it
will return the word "Pass", or otherwise will return the word "Fail".

Thanks,
--
Michelle

It works for me. Post the *exact* formula you used.

If all cells contain a R or if all cells contain a T or if all cells contain
either a R or a T the formula returns Pass. If there are any empty cells or
any entry other than a R or T the formula returns Fail.

--
Biff
Microsoft Excel MVP


"Michelle" wrote in message
...
Thank you, but the formula doesn't give me the correct result. If I have
either "T" or "R" in all the cells, it gives me a "Fail" result, when I
need
a "Pass" result.
--
Michelle


"T. Valko" wrote:

OK, just need a slight modification:

=IF(SUM(COUNTIF(A1:A10,{"R","T"}))=ROWS(A1:A10),"P ass","Fail")


--
Biff
Microsoft Excel MVP


"Michelle" wrote in message
...
Thank you for your replies, but I obviously didn't make myself clear.
Am
trying to create a formula whe if the range of cells has the letter
"R"
or "T" in the cells, then the result will be "pass", but if any cell is
blank
or has a different letter in it, then the result will be "fail".

Thanks,

--
Michelle


"T. Valko" wrote:

I'm assuming you mean if *any* cell in the range contains a R or T.

Assume the range in question is A1:A10...

=IF(SUM(COUNTIF(A1:A10,{"R","T"})),"Pass","Fail")

If *every* cell in the range is empty the result of the formula will
be
Fail. Don't know if that's what you want.

--
Biff
Microsoft Excel MVP


"Michelle" wrote in message
...
Am trying to create a formula that will tell me: if the range of
cells
has
the single letter "R" or the single letter "T" in the individuals
cells,
it
will return the word "Pass", or otherwise will return the word
"Fail".

Thanks,
--
Michelle