J
Joe Smith
I'm trying to learn how to use IF nested with AND by
duplicating a formula in the Asset Depreciation Schedule
downloaded from Microsoft's online templates.
The formula, is copied down from B15 through B43. It is
supposed to give you a numbered list of years up to the
number in D8 (labeled "Useful life"). So if D8=10, you see
1 through 10 appearing from B15:B23. The rest of the
column appears blank.
When I duplicate the formula in a blank spreadsheet and
copy it down, I get the 1 through 10, followed by one
blank cell, followed by #VALUE! throughout the rest of the
range (rather than a continued blank appearance as is the
case in the Asset Depreciation template.
If I delete the formula in the template and recreate it in
the template, it works just fine.
The formula in A15 is:
=IF(AND(B14+1<=$D$8,B14>0),B14+1,"")
Any ideas why the first blank appearing cell in the
template doesn't create an error message but does when
created in a new worksheet?
Thanks in advance for your help and time reading through
this posting.
Joe
duplicating a formula in the Asset Depreciation Schedule
downloaded from Microsoft's online templates.
The formula, is copied down from B15 through B43. It is
supposed to give you a numbered list of years up to the
number in D8 (labeled "Useful life"). So if D8=10, you see
1 through 10 appearing from B15:B23. The rest of the
column appears blank.
When I duplicate the formula in a blank spreadsheet and
copy it down, I get the 1 through 10, followed by one
blank cell, followed by #VALUE! throughout the rest of the
range (rather than a continued blank appearance as is the
case in the Asset Depreciation template.
If I delete the formula in the template and recreate it in
the template, it works just fine.
The formula in A15 is:
=IF(AND(B14+1<=$D$8,B14>0),B14+1,"")
Any ideas why the first blank appearing cell in the
template doesn't create an error message but does when
created in a new worksheet?
Thanks in advance for your help and time reading through
this posting.
Joe