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 |
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) |