Crosswords1 min ago
Blanking out an Excel cell with a formula in it
2 Answers
Does anybody know how to do this? I currently have FALSE inevery sell where the formula is as source cell is blank...here is my formula (nested IF):
=IF(R39
=IF(R39
Answers
Best Answer
No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Perhaps the easiest way is to conceal this cell either by hiding it or formatting its font colour to match its fill colour (such as white on white) and then use another formula to check if the cell is FALSE.
e.g. if the above formula is in cell A1 then use the formula (no spaces)
= IF (A1 = FALSE(),"",A1)
e.g. if the above formula is in cell A1 then use the formula (no spaces)
= IF (A1 = FALSE(),"",A1)
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.