Formulas showing as text rather than values

W

wardellcastles

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
 
B

Bondi

wardellcastles said:
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
Click to expand...

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
 
A

Andy

Bondi said:
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
Click to expand...
Hi

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

Andy.
 
A

Andy

Bondi said:
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
Click to expand...
Hi
Check your Tools/Options/View tab that Formulas is not checked.

Andy.
 
Top