retain cell value

A

aekster

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

Paul

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning 1 of 4 values if conditions are met 4
Merging cells and formats 8
Losing Data From Formulas When Cell Variable Changes 6
Word macro that can call cells out of Excel for a find and replace 0
Excel 2010 Conditional Formatting 2
Word 2016 - Difficulties Learning Style Creation/Application 0
Would like to input 3 letters into a cell, each having a different numerical value 5
Conditional Formatting Conundrum 3

Top