I have a spreadsheet where in one column only any formula I enter displays
as a formula and not as a result of the formula. In Tools | Options we do
NOT have Formulas checkbox selected. Other columns in this spreadsheet
resolve the formulas to values. In the one affected column the formula
reads:

=IF(H163=1099,"x","")

What displays in the cell is the above formula as a string.

What would cause a formula to not calculate a result for one column or cell
only?

--
W