| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when setting a cell to equal a blank cell it displays 0
Try to format the cell as such:
_(* #,##0.00_);_(* (#,##0.00);_(* ""??_);_(@_) -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "BWildeRed" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when setting a cell to equal a blank cell it displays 0
Try this...
=IF(B1="","",B1) -- Biff Microsoft Excel MVP "BWildeRed" wrote in message ... 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. |
| Reply |
| 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 | |||
Hybrid Mode
