Linking spreadsheets and returning value to "0" if no info
 

Okay, let's see if I can explain this right.
I have one worksheet that I am keeping running totals of other worksheets
with multiple sheets. So, when i open the one it has multiple tabs across
the bottom to represent each week of the month. The other worksheet I have a
column for each month and I need to link to a month and each tab within the
month. I believe I have that okay, however I need to tell this to read zero
if there is nothing in the cells that I link.

Thanks.
V

Linking spreadsheets and returning value to "0" if no info
 

Perhaps:
=IF(CellYouReferTo=0,0,Yourformula)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"vtrud" wrote:

Okay, let's see if I can explain this right.
I have one worksheet that I am keeping running totals of other worksheets
with multiple sheets. So, when i open the one it has multiple tabs across
the bottom to represent each week of the month. The other worksheet I have a
column for each month and I need to link to a month and each tab within the
month. I believe I have that okay, however I need to tell this to read zero
if there is nothing in the cells that I link.

Thanks.
V

Linking spreadsheets and returning value to "0" if no info
 

This didn't work. Thanks for trying, though. I was hoping it would.

"Luke M" wrote:

Perhaps:
=IF(CellYouReferTo=0,0,Yourformula)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"vtrud" wrote:

Okay, let's see if I can explain this right.
I have one worksheet that I am keeping running totals of other worksheets
with multiple sheets. So, when i open the one it has multiple tabs across
the bottom to represent each week of the month. The other worksheet I have a
column for each month and I need to link to a month and each tab within the
month. I believe I have that okay, however I need to tell this to read zero
if there is nothing in the cells that I link.

Thanks.
V

Linking spreadsheets and returning value to "0" if no info
 

vtrud wrote:
Okay, let's see if I can explain this right.
I have one worksheet that I am keeping running totals of other worksheets
with multiple sheets. So, when i open the one it has multiple tabs across
the bottom to represent each week of the month. The other worksheet I have a
column for each month and I need to link to a month and each tab within the
month. I believe I have that okay, however I need to tell this to read zero
if there is nothing in the cells that I link.

Thanks.
V

What is your current formula? What result are you getting?

Linking spreadsheets and returning value to "0" if no info
 

Post some examples of your current formulas. Where they are entered and on
which sheet(s).

BTW..........I think you have some syntax problems.

"other worksheets" cannot have multiple sheets.

Do your mean "other workbooks" with multiple worksheets?


Gord Dibben MS Excel MVP

On Mon, 12 Jan 2009 12:44:00 -0800, vtrud
wrote:

Okay, let's see if I can explain this right.
I have one worksheet that I am keeping running totals of other worksheets
with multiple sheets. So, when i open the one it has multiple tabs across
the bottom to represent each week of the month. The other worksheet I have a
column for each month and I need to link to a month and each tab within the
month. I believe I have that okay, however I need to tell this to read zero
if there is nothing in the cells that I link.

Thanks.
V

Linking spreadsheets and returning value to "0" if no info
 

Current formula is: ='[Dec 08.xls]12-5'!$Q$44+'[Dec 08.xls]12-12'!$Q$44+'[Dec
08.xls]12-19'!$Q$44+'[Dec 08.xls]12-26'!$Q$44

The result I am getting is #VALUE!

Each cell that it is pulling from has a formula in it and displays nothing
if there isn't a value greater than zero. Does this have something to do
with it?



"Glenn" wrote:

vtrud wrote:
Okay, let's see if I can explain this right.
I have one worksheet that I am keeping running totals of other worksheets
with multiple sheets. So, when i open the one it has multiple tabs across
the bottom to represent each week of the month. The other worksheet I have a
column for each month and I need to link to a month and each tab within the
month. I believe I have that okay, however I need to tell this to read zero
if there is nothing in the cells that I link.

Thanks.
V

What is your current formula? What result are you getting?

Linking spreadsheets and returning value to "0" if no info
 

Yes, very sorry. I mean workbooks. The workbook I am trying to put this in
is just the one worksheet and looks like this:
Jan Feb Mar
Comp earned
Comp used
Total Comp available 0.00 0.00 0.00
0.00 0.00 0.00
Sick time used
Vacation used
Personal Days (hours)

The workbook I am pulling from looks like this:
"Account
Code" M T W Th F Sa Su "Total Hours"
100
103
104
200
300
400
500
600
And this workbook has a tab/worksheet for each week of the month.
See my formula in the previous post. Does this help?

"Gord Dibben" wrote:

Post some examples of your current formulas. Where they are entered and on
which sheet(s).

BTW..........I think you have some syntax problems.

"other worksheets" cannot have multiple sheets.

Do your mean "other workbooks" with multiple worksheets?


Gord Dibben MS Excel MVP

On Mon, 12 Jan 2009 12:44:00 -0800, vtrud
wrote:

Okay, let's see if I can explain this right.
I have one worksheet that I am keeping running totals of other worksheets
with multiple sheets. So, when i open the one it has multiple tabs across
the bottom to represent each week of the month. The other worksheet I have a
column for each month and I need to link to a month and each tab within the
month. I believe I have that okay, however I need to tell this to read zero
if there is nothing in the cells that I link.

Thanks.
V