If statement

[gbish]

I want to look in multiple cells and return a predetermined value:
I want cell F5 to return a value if there is an X in any of the cells A1
thru A5, if there is no X but there is an R, I want to return a different
value, and if those same cells are empty, I want to return a different value.
Is this possible?
A B C D E F
1 X
2 R
3 X
4
5

 

[Mike H]

Hi,

maybe this

=IF(COUNTIF(A1:A5,"X")>0,"XXXXX",IF(COUNTIF(A1:A5,"R")>0,"RRRRR","No X or R"))

Mike