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


replace A1:A20 with your range


--


Regards,


Peo Sjoblom



"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