View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default How do I set up an IF function with text and numbers?

Hi!

and so on.


"And so on" implies there are more conditions. How many?

Do this mean that ONLY ONE CELL may contain "X"?

If 2 or more cells contain "X", which cell has precedence?

Biff

"Natalie" wrote in message
...
I want a function that recognizes if there is the letter X in cell F7, then
K7 = 5; or if there is an X in cell G7 then K7 = 4, or if there is an X in
H7
then K7 = 3 and so on.