| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell auto population - why 0 when source cell is empty?
Help,
I'm auto populating a cell from another cell contained within another worksheet. However irritatingly, if the source cell contains nothing, it places a 0 in the destination cell. How can I stop this? I'm having to complete a spreadsheet for Monday morning so am having a bit of a crash course in Excel so help is very much appreciated. Regards David |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell auto population - why 0 when source cell is empty?
David,
Will this help? e.g in B1: =IF(ISBLANK(A1),"",A1) "David Smithz" wrote: Help, I'm auto populating a cell from another cell contained within another worksheet. However irritatingly, if the source cell contains nothing, it places a 0 in the destination cell. How can I stop this? I'm having to complete a spreadsheet for Monday morning so am having a bit of a crash course in Excel so help is very much appreciated. Regards David |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell auto population - why 0 when source cell is empty?
One way:
If you're using something like this on Sheet1: =Sheet2!A1 Try this: =IF(Sheet2!A1="","",Sheet2!A1) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "David Smithz" wrote in message . uk... Help, I'm auto populating a cell from another cell contained within another worksheet. However irritatingly, if the source cell contains nothing, it places a 0 in the destination cell. How can I stop this? I'm having to complete a spreadsheet for Monday morning so am having a bit of a crash course in Excel so help is very much appreciated. Regards David |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell auto population - why 0 when source cell is empty?
"Ragdyer" wrote in message ... One way: If you're using something like this on Sheet1: =Sheet2!A1 Try this: =IF(Sheet2!A1="","",Sheet2!A1) -- HTH, Seems to of worked a treat. Thanks for that. David |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell auto population - why 0 when source cell is empty?
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "David Smithz" wrote in message . uk... "Ragdyer" wrote in message ... One way: If you're using something like this on Sheet1: =Sheet2!A1 Try this: =IF(Sheet2!A1="","",Sheet2!A1) -- HTH, Seems to of worked a treat. Thanks for that. David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
| how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
