Odd Excel Formula Problem

  • Thread starter Thread starter Questions
  • Start date Start date
Q

Questions

I am building a spreadsheet tool that pulls data from either another sheet or
another workbook. In both cases, when I write my formulas, the seem to work
initially, but at some point something happens and instead of displaying the
result of the formula, they display the formula as text.

For example:

In Cell A1 I type =if($A$2=$A$3,1,0) initially it display's my desired
result ("0"). Then, if I go in and try to unlock the cells to copy down and
across the formula result changes to "=if($A$2=$A$3,1,0)"

I have never seen this error and can't figure out why it's happening. I
tried reformatting and settings and those don't seem to be the problem.

Any thoughts?
 
After reformatting the cells as General you should open each for editing.
Or Delete the text, format the cells and recopy the formulas
best wishes
 
Back
Top