On Tuesday, August 26, 2008 at 4:18:00 AM UTC+2, Michelle wrote:
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

IF(A1:A20< 10,"FAIL,"PASS") What is wrong with this formula? Please help.