| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple cell reference not blank
Whenever I do a simple cell reference, e.g.
=A1 if A1 is blank the resultant cell shows a zero. I'm getting tired of =IF(A1="","",A1) Without changing the cell format is there a setting or different formula syntax to make the resultant cell equal the source cell literally? TIA Charlie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a blank formula cell if the reference is blank? | Excel Worksheet Functions | |||
| returning blank when reference cell is blank | Excel Worksheet Functions | |||
| how to get excel to display blank if reference cell blank | Excel Worksheet Functions | |||
| Simple +formula not reading value from the reference cell | Excel Programming | |||
| Simple way to add a reference to a cell | Excel Programming | |||
Threaded Mode
