| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Clear a cell from within a formula
When I plot data I dont want plots to jump to 0 and back where there is
missing data. The data are being created with formulas so I need to find out how to make a formula result a cleared cell rather than 0 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Clear a cell from within a formula
try
=if(formula=0,NA(),formula) "Stew Kimble" wrote: When I plot data I dont want plots to jump to 0 and back where there is missing data. The data are being created with formulas so I need to find out how to make a formula result a cleared cell rather than 0 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to clear a value but not the formula? | Excel Discussion (Misc queries) | |||
| Is there a formula to clear the contents of a specific cell? | Excel Worksheet Functions | |||
| Clear Cell Without Removing Formula | Excel Worksheet Functions | |||
| Clear cell from formula? | Excel Discussion (Misc queries) | |||
| Clear Contents But Not Formula | Excel Discussion (Misc queries) | |||
Linear Mode
