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

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.