Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've the following Excel UDF function (C#) which works if invoked from Excel.
Would like to display function description and association help. Tried different attributes but wasn't succesful. /// <summary /// Calculate Income Tax. /// </summary /// <param name="income"income for which tax is to be ascertained</param /// <returnstaxable amount</returns /// public double Tax(double income, [Optional] string incomeFromOtherSources) [System.EnterpriseServices.Description("Calculate Income Tax"), HelpKeyword("Help Keyword Attribute")] public double Tax(double income) { if (income 0 && income <= 7000) { return (.10 * income); } if (income 7000 && income <= 28400) { return 700.00 + (.15 * (income - 7000)); } if (income 28400 && income <= 68800) { return 3910.00 + (.25 * (income - 28400)); } if (income 68800 && income <= 143500) { return 14010.00 + (.28 * (income - 68800)); } if (income 143500 && income <= 311950) { return 34926.00 + (.33 * (income - 143500)); } if (income 311950) { return 90514.50 + (.35 * (income - 311950)); } return 0; } thanks guys for all your help, Rama |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
File Property Keyword Search | Excel Discussion (Misc queries) | |||
Limitation to length of Add-In description causes add-in manager to report the add-in file missing. | Excel Discussion (Misc queries) | |||
Excel 2000 Help File - What keyword | Excel Discussion (Misc queries) | |||
Excel VBA - determine location of a keyword | Excel Programming | |||
Excel Splitting Up Data By Keyword | Excel Programming |