Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro to find and delete all FALSE statements
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. |
#2
|
|||
|
|||
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 -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "Woody13" wrote in message ... 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. |
#3
|
|||
|
|||
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. "Bernard Liengme" wrote: 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 -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "Woody13" wrote in message ... 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. |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|