Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yield fomula error #Name?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yield fomula error #Name?
Eddie,
This function is part of the analysis toolpak so try Tools|Addins and check the analysis toolpak option. Mike "Eddie" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yield fomula error #Name?
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. "Eddie" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yield fomula error #Name?
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 On Mon, 5 Jan 2009 09:11:02 -0800, Eddie wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yield fomula error #Name?
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? "BobT" wrote: 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. "Eddie" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yield fomula error #Name?
Thanks that worked....and thanks to everyone else.
"Gord Dibben" wrote: 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 On Mon, 5 Jan 2009 09:11:02 -0800, Eddie wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
yield of a security | Excel Worksheet Functions | |||
what is PAR in the Yield Function | Excel Worksheet Functions | |||
yield function | Excel Worksheet Functions | |||
Yield rate | Excel Worksheet Functions | |||
yield to call | Excel Discussion (Misc queries) |