Automatic formula insertion

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I have a column with formulas. In the column I skip a
cell periocically (i.e. not every cell in the column has a
formula). The column to the right is used as a switch to
determine if the formula should be evaluated or not.
(1=evaluate, anything else=do not evaluate). If I put a
value in the 'switch' column next to a cell that does not
have a value - Excel automatically put a formula into that
cell. I suspect there is an option I need to turn off.
Excel probably thinks that I forgot to put a formula in
that cell (since the formula exists immediately above and
below).
Any input would be appreciated.
Thanks
Todd
 
There's an option under Tools|options|Edit tab
Extend list formats and formulas

that could be turned off.

(If I recall correctly, this was added in xl2k.)

And I'm not sure what your formula is, but maybe you want to check to see if
that trigger value cell is empty and react that way.

=if(a9="","",yourformulahere)

Then you might not have to worry about the formulas at all.
 
Back
Top