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 EditGot To
Click the Special button
Select Formulas
Remove the check marks from all options except Logical
Click OK
Press the Delete key


Woody13 wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html