Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you use a formula to make a truly "blank" cell
I have a setup that (simplified slightly) looks like:
A1: 20 B1: =if(A1<50,"",A1) C1: =isblank(B1) C1: produces "false". Why? Isn't "" supposed to put "nothing" into a cell? The point of all this: I want the cell to be truly blank, so that it doesn't graph as a "zero" in a chart. (Yes, I have the option under ToolsOptions checked, so that blank values are not plotted as zeros.) However, it is graphing my "not quite blank" cells, generated by the above formula, as zeros. It does skip truly blank values (if I delete the formula altogether), but doesn't when I try to force blank values using a formula like this. Any ideas how to get a formula to make a cell think it is blank? Thank you, Heidi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
FORMULA TO MAKE CELL COLOR CONTINGENT | Excel Discussion (Misc queries) | |||
how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) |