Temporarily overriding a Formula
Posted by Marion on January 23, 2002 7:51 AM
So many questions today -
You are all saving my life as I'm trying to learn Excel on the fly
for a one-day project!
In Quattro, if I want to temporarily override the formula in a cell,
I simply place the value before the formula, and add a semi-colon before the formula.
To go back to the formula, I simply edit out the temporary value and the semi-colon, and voila, there
is my formula waiting for me.
In Excel, it seems that I have to:
A> create a comment as a holding place for my formula.
B> place the value in a separate cell, and create an IF statement in my formula
(so that the answer is either the value from the separate cell, or the value of the formula)
Is that true?
Any other alternatives?
Thanks so much -