If statement

  • Thread starter Thread starter gbish
  • Start date Start date
G

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
 
Hi,

maybe this

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

Mike
 
Back
Top