Macro to find and delete all FALSE statements

W

Woody13

So i have a sheet filled with formulas and I have put IF,Then statements in
them to return FALSE is I don't get the result I want. However, I need to
erase all these FALSE results so they do not plot as zero on my chart.
Anyway to create a macro? Thanks.
 
B

Bernard Liengme

You may not need a macro.
If you formulas are of the type =IF(A1<10,FALSE,A1), select the range and
use Edit | Replace to change FALSE to NA(). The NA() will show in cell as
#N/A and will be ignored by the chart.

best wishes
 
W

Woody13

Thanks. You are correct but it makes it more difficult for me to go back and
review some of the information. Still, you suggestion was helpful.
 
D

Debra Dalgleish

You could record a macro as you do the following --

To delete the cells that have a FALSE result:
Select the cells with formulas
Choose Edit>Got To
Click the Special button
Select Formulas
Remove the check marks from all options except Logical
Click OK
Press the Delete key
 
Top