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