| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get linked file from worksheet to = "blank"
Hi people of the superior power of excel, I have 2 worksheets Apple and Orange. Field A1 in Apple worksheet contains no information "blank" nothings entered. I want to copy the information in A1 Apple to A2 Orange. I assumed Field A2 Orange = Apple!A1. but the field shows the value 0. I changed the properties to text but it still shows 0. What is the correct formula to ensure field A2 Orange = "blank"? -- seno |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get linked file from worksheet to = "blank"
=IF(ISBLANK(Apple!A1), "", Apple!A1)
It'll return the value of Apple!A1 if a non-blank value exists, but return blank is Apple!A1 is blank. -- Location: Sydney Occupation: Actuarial Consultant (Project Finance/Financial Modeling) "seno" wrote: Hi people of the superior power of excel, I have 2 worksheets Apple and Orange. Field A1 in Apple worksheet contains no information "blank" nothings entered. I want to copy the information in A1 Apple to A2 Orange. I assumed Field A2 Orange = Apple!A1. but the field shows the value 0. I changed the properties to text but it still shows 0. What is the correct formula to ensure field A2 Orange = "blank"? -- seno |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get linked file from worksheet to = "blank"
If you have a formula which returns a blank on that first sheet, then
you will need to do it this way: =IF(Apple!A1="","",Apple!A1) Copy across and down as required. Hope this helps. Pete On Apr 16, 9:07*am, seno wrote: Hi people of the superior power of excel, I have 2 worksheets Apple and Orange. Field A1 in Apple worksheet contains no information "blank" nothings entered. I want to copy the information in A1 Apple to A2 Orange. I assumed Field A2 Orange = Apple!A1. but the field shows the value 0. I changed the properties to text but it still shows 0. What is the correct formula to ensure field A2 Orange = "blank"? -- seno |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get linked file from worksheet to = "blank"
Thanks a mill it works. -- seno |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get linked file from worksheet to = "blank"
You're welcome - thanks for feeding back.
Pete On Apr 17, 12:45*am, seno wrote: Thanks a mill it works. -- seno |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
| Avoiding "0" importing blank cells from another Excel file | Excel Discussion (Misc queries) | |||
| If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Worksheet Functions | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Linear Mode
