Function help needed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Xavier Bourguignon - 30 Nov 2004 11:07 GMT

Hello, I have written the code below, and gives me a #NAME? error, I
went to look up the error and the possible causes but I don't quite
understand what could be wrong, I am new to Excel, can anybody help
please?

=IF($D27="Yearly",EDATE($E27,12),IF($D27="3
Months",EDATE($E27,3),IF($D27="1st 6
Months",EDATE($E27,3),IF($D27="2nd 6 Months",EDATE($E27,6)))))

Thank you in advance.
Kelter

Reply to this Message

JulieD - 30 Nov 2004 11:24 GMT

Hi Xavier

for this function to work you need to have the analysis tool-pak installed
(tools / add-ins / analysis tool-pak).

Cheers
JulieD

> Hello, I have written the code below, and gives me a #NAME? error, I
> went to look up the error and the possible causes but I don't quite
[quoted text clipped - 7 lines]
> Thank you in advance.
> Kelter

Reply to this Message

Xavier Bourguignon - 30 Nov 2004 12:11 GMT

Now I am getting a #VALUE? error..

>Hi Xavier
>
[quoted text clipped - 15 lines]
>> Thank you in advance.
>> Kelter

Reply to this Message

JulieD - 30 Nov 2004 12:42 GMT

Hi

what is in D27 and E27 (right mouse click on each in turn and choose
"general" to see what is really in the cell).

Cheers
JulieD

> Now I am getting a #VALUE? error..
>
[quoted text clipped - 17 lines]
>>> Thank you in advance.
>>> Kelter

Reply to this Message

Don Guillett - 30 Nov 2004 12:53 GMT

I just tested your code and got a value if the cell was blank but the space
bar had been touched. Use the delete key to clear the e27 cell or put in a
date.

Signature

Don Guillett
SalesAid Software
donaldb@281.com

> Now I am getting a #VALUE? error..
>
[quoted text clipped - 17 lines]
> >> Thank you in advance.
> >> Kelter

Reply to this Message