I am trying to us an IF Function with the EDATE function. I have the EDATE
formula correct but when I try to put in the IF, I get the error message
#NAME?

What am I doing wrong?

You need to have ATP (Analysis ToolPak) installed, it comes with
office/excel, install under toolsadd-ins, then check it, keep the cd handy
and follow the instructions

--

Regards,

Peo Sjoblom

"JamieO" wrote in message
...
I am trying to us an IF Function with the EDATE function. I have the
EDATE
formula correct but when I try to put in the IF, I get the error message
#NAME?

What am I doing wrong?

I am actually doing a report for an Excel class that I am taking. I don't
believe that my professor would give us an assignment that would require
installing something extra. Is this the only way to get what I am looking
for? What I am working on is a car loan. The months of the loan is 36
months and I have listed in column A #'s 1-36 consecutively. The formula I
am using is to calculate the due date of each function for month 1, 2, 3,
etc...... In cell D2 I have 36 as the length of the loan. I am using
=EDATE($D$2,A11) and copying it down to the 36th month in column A. This
works, but if I change the length of the loan to 24, I need the cells in
column A for months 25-36 to appear as blank. The if formula I tried to use
is =IF(A11$D$5," ",EDATE($D$2,A11)). Why won't this work?

"Peo Sjoblom" wrote:

You need to have ATP (Analysis ToolPak) installed, it comes with
office/excel, install under toolsadd-ins, then check it, keep the cd handy
and follow the instructions

--

Regards,

Peo Sjoblom

"JamieO" wrote in message
...
I am trying to us an IF Function with the EDATE function. I have the
EDATE
formula correct but when I try to put in the IF, I get the error message
#NAME?

What am I doing wrong?

Fine! Don't install ATP but then you can't use the function

--

Regards,

Peo Sjoblom


"JamieO" wrote in message
...
I am actually doing a report for an Excel class that I am taking. I don't
believe that my professor would give us an assignment that would require
installing something extra. Is this the only way to get what I am looking
for? What I am working on is a car loan. The months of the loan is 36
months and I have listed in column A #'s 1-36 consecutively. The formula
I
am using is to calculate the due date of each function for month 1, 2, 3,
etc...... In cell D2 I have 36 as the length of the loan. I am using
=EDATE($D$2,A11) and copying it down to the 36th month in column A. This
works, but if I change the length of the loan to 24, I need the cells in
column A for months 25-36 to appear as blank. The if formula I tried to
use
is =IF(A11$D$5," ",EDATE($D$2,A11)). Why won't this work?

"Peo Sjoblom" wrote:

You need to have ATP (Analysis ToolPak) installed, it comes with
office/excel, install under toolsadd-ins, then check it, keep the cd
handy
and follow the instructions

--

Regards,

Peo Sjoblom

"JamieO" wrote in message
...
I am trying to us an IF Function with the EDATE function. I have the
EDATE
formula correct but when I try to put in the IF, I get the error
message
#NAME?

What am I doing wrong?