Function help needed

  • Thread starter Thread starter Xavier Bourguignon
  • Start date Start date
X

Xavier Bourguignon

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
 
Hi Xavier

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

Cheers
JulieD
 
Now I am getting a #VALUE? error..

Hi Xavier

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

Cheers
JulieD
Click to expand...
 
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
 
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.
 
Back
Top