View Single Post
  #1   Report Post  
Matt
 
Posts: n/a
Default Logical Test if statements with text--Excel 2002

I am trying to format a cell to check and see values for a range of other
cells. If the value of the cell is a text letter (r, y, g, or c) I want the
value to be returned to be whatever letter it was. How can I do thies?