View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wardellcastles
 
Posts: n/a
Default Formulas showing as text rather than values

I have this formula in a cell
=IF(A2=A3,"Match", "NoMatch")

However what shows in that cell is the =IF statement itself, not the
value "Match" or "NoMatch".

Any suggestions are welcome