Arrrgh...More Excel Problems (Strange Row # Problem)

[Grizwold]

Unfortunately I'm working with a large spreadsheet, and have a ton of room for improvement. Even though my simple spreadsheets work perfect, I constantly have ideas for improvement, which requires more complex formulas that are accident prone. This is a formula that resembles the balance on mortgage(s) at the end of each year. I've entered 5 such formulas that work fine but when I come to row 100, there is a problem, the display in the cell reads #VALUE!...

This formula works fine:

=IF(Assumptions!L8=3,SUM('First Mortgage'!I88+'Second Mortgage'!I88+'Third Mortgage'!I88),IF(Assumptions!L8=2,SUM('First Mortgage'!I88+'Second Mortgage'!I88),IF(Assumptions!L8=1,'First Mortgage'!I88,IF(Assumptions!L8=0,0))))

This formula does not work:

=IF(Assumptions!L8=3,SUM('First Mortgage'!I100+'Second Mortgage'!I100+'Third Mortgage'!I100),IF(Assumptions!L8=2,SUM('First Mortgage'!I100+'Second Mortgage'!I100),IF(Assumptions!L8=1,'First Mortgage'!I100,IF(Assumptions!L8=0,0))))

The only thing that is changed is the row number from 88 to 100. I've also tried row 112, which does not work. So I guess there is some problem with triple digit row numbers?

Any advice is appreciated. Sorry to post many excel questions, and I fear I may have a few more this weekend.

Clark

[Grizwold]

I managed to get the correct value by trying a new formula I found, Offset, which allows me to refer to cells in any range.