Home |
Search |
Today's Posts |
#1
|
|||
|
|||
blank cells
this is a question on fundamentals of excel
for e.g. cell A2 is blank. I confirm whether A2 is blank by going to another cell and typing <=isblank(A2) which gives <true. But when I go to another cell and click edit-clear-all (to celar any formats etc) and type <=A2 it does NOT give a blank cell but gives <0(zero). If I copy and paste a blank cell to another cell it gives blank. the above descrepancy gives problem in creating formulas. for e.g. A2 is 2, A3 is blank If I type in some other cell the formula <=IF(A2=2,A3," ") it gives 0 and not Blank which A3 is . is it because if the condition is true it is blank and even if it is false it is blank. this formula may be trivial but I have a formula which gives this type of problem. Elucidation please. |
#2
|
|||
|
|||
This is a fundamental Excel need, in order for basic mathematics to work in
Excel it is important for any blank cells to have the value of "0", otherwise SUMing (A1:A10) would fail if some of the cells were truely blank. If you enter "=A2" and A2 is blank because you are expecting a result (otherwise you would not have entered the formulae) the assumed "0" is displayed. Hope this helps. Kevin "R.VENKATARAMAN" wrote: this is a question on fundamentals of excel for e.g. cell A2 is blank. I confirm whether A2 is blank by going to another cell and typing <=isblank(A2) which gives <true. But when I go to another cell and click edit-clear-all (to celar any formats etc) and type <=A2 it does NOT give a blank cell but gives <0(zero). If I copy and paste a blank cell to another cell it gives blank. the above descrepancy gives problem in creating formulas. for e.g. A2 is 2, A3 is blank If I type in some other cell the formula <=IF(A2=2,A3," ") it gives 0 and not Blank which A3 is . is it because if the condition is true it is blank and even if it is false it is blank. this formula may be trivial but I have a formula which gives this type of problem. Elucidation please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
how to skip the blank cells | Excel Discussion (Misc queries) |