| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
reference a blank cell
When I reference a blank cell, the result is "0" but I want the result to be
blank as well. Is this a formatting issue? Example: A1 is blank my formula for cell C1 is =A1, which results in 0 (I want it to be blank) eventually, when I fill in A1, I want C1 to show the same result. I just dont want a bunch of zeros all over my sheet! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| Flexible Cell Reference | Excel Discussion (Misc queries) | |||
| blank cell turns to 0 | New Users to Excel | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
