Using IF Function with EDATE Function

[JamieO]

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?

[Peo Sjoblom]

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

--

Regards,

Peo Sjoblom

"JamieO" <JamieO@discussions.microsoft.com> wrote in message
news:3D24DA65-61C3-4A4A-8AC4-677E4C067794@microsoft.com...
> 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?

[JamieO]

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 tools>add-ins, then check it, keep the cd handy
> and follow the instructions
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "JamieO" <JamieO@discussions.microsoft.com> wrote in message
> news:3D24DA65-61C3-4A4A-8AC4-677E4C067794@microsoft.com...
> > 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?
>
>
>

[Peo Sjoblom]

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

--

Regards,

Peo Sjoblom


"JamieO" <JamieO@discussions.microsoft.com> wrote in message
news:F5D020AA-9D0C-40D3-B6B1-6A74D0352540@microsoft.com...
> 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 tools>add-ins, then check it, keep the cd
handy
> > and follow the instructions
> >
> > --
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> > "JamieO" <JamieO@discussions.microsoft.com> wrote in message
> > news:3D24DA65-61C3-4A4A-8AC4-677E4C067794@microsoft.com...
> > > 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?
> >
> >
> >