| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
when setting a cell to equal a blank cell it displays 0
If I make cell A1=B1 the result in A1 is 0 (zero) if B1 is blank. Is it
possible to have a blank result in A1? I am trying to create a template where I have some cells equate to others and I would like the cells to show blank if there is no data in the target cells. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting Cells Equal only if Destination Cell Does Not Have a Formu | Excel Discussion (Misc queries) | |||
| Setting a cell equal to another worksheet cell fails (sometimes) | Excel Worksheet Functions | |||
| Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
| Setting Purely BLANK Cell | Excel Worksheet Functions | |||
| make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
Threaded Mode
