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

 

[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]

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