I have a spreadsheet in which I am accessing data from a page in the
spreadsheet. For example:
Cell C9 = +Tech_No where Tech_No is defined on another page in the
spreadsheet. For some reason, when I type in a change to the formula,
the formula appears rather than the value of the formula. For example,
I changed, one of the cells to be:

=if(value(tech_no) = 0,"",tech_no))

Rather than "" or tech_no, what appeared in the cell was the actual
formula. I believe I may have a setting that is not correct.

Can anyone help? Thanks.

Connie