Yield fomula error #Name?

[Eddie]

Hello all, one of my users keeps getting this error #Name? for the following
yield fomula
=(YIELD(TODAY()+3,L10,((VLOOKUP(YEAR(L10)-YEAR(TODAY()),$P$7:$Q$22,2,FALSE)+J11/100))/100,I11,100,4)*100)

She fixes it and when she sends it to someone else they get the error or if
she opens it at a later time she gets the #Name? again. It was created in
excel 2003 but then she used excel 2007 to make changes but saves it in 2003
format.

Any help would be much appreciated.

Thanks,
Eddie

 

[Mike H]

Eddie,

This function is part of the analysis toolpak so try

Tools|Addins and check the analysis toolpak option.

Mike

 

[BobT]

YIELD is a custom function - i.e. it won't be on everyones install of Excel.
Likely the YIELD function is sitting in her PERSONAL.XLS file or within some
other spreadsheet that she normally has open (or in an Excel add-in that she
uses and other don't).

Either track down where the YIELD function is stored on her system and get
it embeded into the file she's sending out or put it into everyone else's
PERSONAL.XLS file. Or have her rewrite the formula to avoid the YIELD
function.

 

[Gord Dibben]

Help on YIELD reveals this tidbit.

"If this function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in."

Amazing stuff can be found when using Excel Help.


Gord Dibben MS Excel MVP

 

[Eddie]

how would I go about enbeding it? I just did a search on my computer and
couldn't find the personal.xls file? where would it reside?

 

[Eddie]

Thanks that worked....and thanks to everyone else.