| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
0 in linked cells when watched
i have linked some cells in excell to another work sheet but if sheet 1 has
no data in the cell then sheet 2 shows a 0 how do i keep the linked / watched cell but not return the zero on the second sheet.?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
0 in linked cells when watched
Hi Steve
=IF(Sheet2!A1="","",Sheet2!A1) Regards Roger Govier steve wrote: i have linked some cells in excell to another work sheet but if sheet 1 has no data in the cell then sheet 2 shows a 0 how do i keep the linked / watched cell but not return the zero on the second sheet.?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking linked cells | Excel Worksheet Functions | |||
| Finding linked cells to other workbooks | Excel Discussion (Misc queries) | |||
| Show cells have been read - linked | Excel Discussion (Misc queries) | |||
| Linked cells, make the data go hard manually | Excel Discussion (Misc queries) | |||
| How to keep linked cells blank until information is entered? | Excel Worksheet Functions | |||
Linear Mode
