Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a cell empty
I have a column of numbers in a1 to a100. I would like to do an if test in
column B. If the value of the number in column A is less than 100 I want the value resulting from the if test to be the value in column A. If however the value in column A is greater than or equal to 100 I want the corresponding cell in column B to be empty. I know how to do an If function, but what I am not sure about is how to make the False Value in the If function result in a cell being empty (I don't want 0 or ""). The reason I want to do this is so that when I chart this data from column B on a line chart I want those values in column B that are empty not to have a marker on the chart. Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a cell blank or empty without deleting it | New Users to Excel | |||
How can Excel make a cell empty without making it na()? | Excel Discussion (Misc queries) | |||
Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Function making cell really "empty" | Excel Worksheet Functions |