retain cell value

aekster · Oct 24, 2003

What function to use to retain numerical cell value if ceratain
conditions are not met, otherwise calulate according to the formula?

Paul · Oct 24, 2003

aekster said:
What function to use to retain numerical cell value if ceratain
conditions are not met, otherwise calulate according to the formula?

Rewrite the formula, perhaps using an IF statement like this:
=IF(conditions, original_formula, fixed_value).