dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
412
share rss forum feed


beck
Premium,MVM
join:2002-01-29
On The Road
kudos:1
Reviews:
·Stablehost.com

[Excel] Referencing a formula in another sheet

#1:
I have a 2 week timesheet on each sheet. Just because, I made 30 of them in the workbook. F1 is the starting date for the season. L1 contains this formula and it works fine. I have to fill in F1 each 2 weeks on each sheet.
=IF(ISNUMBER(F1);( F1+13); "" )

I'm lazy.

So, the next sheet (sheet2) I would like it to look at L1 of the previous sheet and fill in F1 as L1+1.
=IF(ISNUMBER(sheet1!L1); (sheet1!L1+1);"" )

This never works. Even if I don't check to see if there is a number there. I assume it's because L1 is a formula and not a real date. L1+1 works in the same sheet, just not with the Sheet1!L1+1. Can this be fixed? What am I doing wrong?
--
Damn spy drones!
They are interfering
with my sun spots.


MrWhsprs
Premium
join:2000-04-22
Round Lake, IL

1 edit
I have Excel 2003 and did this:

Sheet1 cell F1 is a date (I entered 9/1/12 for this example).
Sheet1 cell L1 I put the formula =IF(ISNUMBER(F1),F1+13,"")
Sheet2 cell F1 I put the formula =IF(ISNUMBER(Sheet1!L1),Sheet1!L1+1,"")
Sheet2 cell L1 I put the formula =IF(ISNUMBER(F1),F1+13,"")

Sheet1 cell F1 shows 9/1/2012
Sheet1 cell L1 shows 9/14/2012
Sheet2 cell F1 shows 9/15/2012
Sheet2 cell L1 shows 9/28/2012

Is that the kind of result you're after?

Note: In Excel 2003 if I try to use a semicolon in the formula instead of a comma, I get an error message about the formula having an error.

--
Mike


beck
Premium,MVM
join:2002-01-29
On The Road
kudos:1
reply to beck
Thank you! That was it. I don't do enough in Excel to know differences between versions. I'm using Excel 2003.


MrWhsprs
Premium
join:2000-04-22
Round Lake, IL
You're welcome; I'm glad I was able to help!
--
Mike