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

Formulas showing as text rather than values
 

wardellcastles wrote:
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

Hi,

It could be that your cell is formated at Text.
Try to delete the formual and then Format the cell as Generel. Then
re-enter the fromula.

Regards,
Bondi

Formulas showing as text rather than values
 

Bondi wrote:
wardellcastles wrote:
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

Hi,

It could be that your cell is formated at Text.
Try to delete the formual and then Format the cell as Generel. Then
re-enter the fromula.

Regards,
Bondi

Hi

Check your Tools/Options/View tab and make sure that Formulas is not
checked.

Andy.

Formulas showing as text rather than values
 

Bondi wrote:
wardellcastles wrote:
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

Hi,

It could be that your cell is formated at Text.
Try to delete the formual and then Format the cell as Generel. Then
re-enter the fromula.

Regards,
Bondi

Hi
Check your Tools/Options/View tab that Formulas is not checked.

Andy.