| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In a linked calculation how do I lose the '0' in the linked file?
I've linked 1 excel file to another. Some fields in origin file are empty,
in linked file they show as a '0'. How do I lose the '0'? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In a linked calculation how do I lose the '0' in the linked file?
You could use something like
=if(isblank( inked info ),ValueIfTrue,ValueIfFalse) "Anita" wrote: I've linked 1 excel file to another. Some fields in origin file are empty, in linked file they show as a '0'. How do I lose the '0'? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In a linked calculation how do I lose the '0' in the linked file?
"Anita" wrote
I've linked 1 excel file to another. Some fields in origin file are empty, in linked file they show as a '0'. How do I lose the '0'? Another way is to frame the link formulas along these lines: =IF(Sheet1!A1="","",Sheet1!A1) =IF([Book1]Sheet1!A1="","",[Book1]Sheet1!A1) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Someone moved my linked file | Excel Worksheet Functions | |||
| How do I which file in collection is being used in the calculation | Excel Discussion (Misc queries) | |||
| Formula calculation in a Shared Excel File | Excel Discussion (Misc queries) | |||
| How do I unlock FILE access? | Excel Discussion (Misc queries) | |||
| File Size - Calculation | Excel Discussion (Misc queries) | |||
Hybrid Mode
