Blanking out an Excel cell with a formula in it

funkylad20 | 16:12 Thu 01st Oct 2009 | Computers

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

CD quality

Blank screen

Answers

1 to 2 of 2

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.

funkylad20

Question Author

OK, HERE IS THE FORMULA, SEE IF IT WORKS THIS TIME (ignore spaces):

= IF (R39 < D20-2,B19,IF(R39 < D21-2,B20,IF(R39 < D22-2,B21,IF(R39 < D23-2,B22,IF(R39 < D24-2,B23,IF(R39 < D25-2,B24,IF(R39 < D2-2,B25,IF(R39 < D3-2,B2))))))))

ABerrant

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)

1 to 2 of 2

Do you know the answer?