Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Yearfrac problem
I have Excel 2002 in spanish. I created a system that calculates the interest
service from varios kind of debt from a Company. It requires to use the yearfrac function to calculate how many days between each payment are to be taken into account for the calculation of interest, given the diversity in the types of bonds that this company issued. The system requires to open for example 3 BIG!!! workbooks at the same time (stock, cupons and proyected service) stock and cupon feed proyected service, so they are linked. The function yearfrac is used in the workbook "cupons". I have activated the add-ins required to use yearfrac. However when I open the 3 workbooks I find that every place where I used the function yearfrac in the woorkbook cupons the system substituted it for another name using the path of the program ATPVBAEN.XLA , and aditionally it introduced the latter as an external link!!!!! which I did no create. After that the workbook "cupons" give me the error #Value where it is suppose to calculate yearfrac!!!!. Could somebody please help me and tell me how to correct it and why it happen!!!!! Thanks a lot!!! Adriana |
#2
|
|||
|
|||
Hi Adriana,
As far as I know, the functions included into the Microsoft Analysis ToolPack are not authomatically translated accross different language platforms. So you will either have to substitute the function name with its Spanish version (FRAC.ANO) manually or create a formula, which uses standard Excel functions. I guess, using the function DETEDIF (Spanish SIFECHA is a bizarre translation :-)) could do the trick as, I think, it is authomatically translated and even in Spanish version requires english constants, e.g. =SIFECHA(A1,B1,"Y") where "Y" stands for Yearss instead of expected "A" - Ano. For more info, see Excel help regarding this function (documented as from XL2000 version) Hope this helps. Saludos, KL "Adriana" wrote in message ... I have Excel 2002 in spanish. I created a system that calculates the interest service from varios kind of debt from a Company. It requires to use the yearfrac function to calculate how many days between each payment are to be taken into account for the calculation of interest, given the diversity in the types of bonds that this company issued. The system requires to open for example 3 BIG!!! workbooks at the same time (stock, cupons and proyected service) stock and cupon feed proyected service, so they are linked. The function yearfrac is used in the workbook "cupons". I have activated the add-ins required to use yearfrac. However when I open the 3 workbooks I find that every place where I used the function yearfrac in the woorkbook cupons the system substituted it for another name using the path of the program ATPVBAEN.XLA , and aditionally it introduced the latter as an external link!!!!! which I did no create. After that the workbook "cupons" give me the error #Value where it is suppose to calculate yearfrac!!!!. Could somebody please help me and tell me how to correct it and why it happen!!!!! Thanks a lot!!! Adriana |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
EXCEL 2003 PROBLEM | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |