DCF
HI,
I used to use Excel 97 and used a formula called "DCF". However, since I have upgraded to Excel 2003, it does not recognise this formula. Has anyone heard of it, and know how to get it back? I can't find anything about it. Any example of the formula would be: =DCF(a1,b1,"DCF_ACT_365") where a1 and b1 are dates. I have figured a work around but with the number of places this formula is in, it would make it difficult and annoying! I hope someone can help. Thanks |
DCF
hi,
sounds like a user difined function(udf). you may have to re-create it. http://office.microsoft.com/en-us/ex...CL100570551033 Regards FSt1 "Mark Costello" wrote: HI, I used to use Excel 97 and used a formula called "DCF". However, since I have upgraded to Excel 2003, it does not recognise this formula. Has anyone heard of it, and know how to get it back? I can't find anything about it. Any example of the formula would be: =DCF(a1,b1,"DCF_ACT_365") where a1 and b1 are dates. I have figured a work around but with the number of places this formula is in, it would make it difficult and annoying! I hope someone can help. Thanks |
DCF
I don't recognise this - perhaps it is a user-defined function that
might have been included in an add-in. Hope this helps. Pete On Jun 19, 11:16 am, Mark Costello <Mark wrote: HI, I used to use Excel 97 and used a formula called "DCF". However, since I have upgraded to Excel 2003, it does not recognise this formula. Has anyone heard of it, and know how to get it back? I can't find anything about it. Any example of the formula would be: =DCF(a1,b1,"DCF_ACT_365") where a1 and b1 are dates. I have figured a work around but with the number of places this formula is in, it would make it difficult and annoying! I hope someone can help. Thanks |
DCF
thank you both, I managed to find it in Visual Basic. Didn't even know user
defined functions existed! "Pete_UK" wrote: I don't recognise this - perhaps it is a user-defined function that might have been included in an add-in. Hope this helps. Pete On Jun 19, 11:16 am, Mark Costello <Mark wrote: HI, I used to use Excel 97 and used a formula called "DCF". However, since I have upgraded to Excel 2003, it does not recognise this formula. Has anyone heard of it, and know how to get it back? I can't find anything about it. Any example of the formula would be: =DCF(a1,b1,"DCF_ACT_365") where a1 and b1 are dates. I have figured a work around but with the number of places this formula is in, it would make it difficult and annoying! I hope someone can help. Thanks |
All times are GMT +1. The time now is 08:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com