| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the Zero Cap function in excel?
Not sure what the Zero Cap function is or where to find it? Please advise!
Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the Zero Cap function in excel?
I, personally, have not heard of this one yet. Maybe you mean 'Floor',
'Ceiling', 'Lower', or 'Upper'. Check the help menu for the details on these. Maybe you are referring to a user defined function. If this is the case you will have to provide a lot more details and, most likely, post your question to the 'Excel Programming' discussion group. Hope that helps. Regards, Ryan--- -- RyGuy "KICI" wrote: Not sure what the Zero Cap function is or where to find it? Please advise! Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the Zero Cap function in excel?
Maybe I do....I really dont know it is to do with an accounting interview as
you can see - not doing too well so far :( Anyway, I will have a look at your suggestions and if anyone else can advise further, it would be much appreciated. Thanks "ryguy7272" wrote: I, personally, have not heard of this one yet. Maybe you mean 'Floor', 'Ceiling', 'Lower', or 'Upper'. Check the help menu for the details on these. Maybe you are referring to a user defined function. If this is the case you will have to provide a lot more details and, most likely, post your question to the 'Excel Programming' discussion group. Hope that helps. Regards, Ryan--- -- RyGuy "KICI" wrote: Not sure what the Zero Cap function is or where to find it? Please advise! Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the Zero Cap function in excel?
On Wed, 12 Dec 2007 03:45:01 -0800, KICI
wrote: Not sure what the Zero Cap function is or where to find it? Please advise! Thanks I'm not aware of any native Excel function with that name. Perhaps it is part of an add-in. --ron |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the Zero Cap function in excel?
If you have a list of net cap categories, and one of them is zero, you
can use a lookup formula or INDEX/MATCH combination to return the cap multiple for a particular capital measure. I don't know that there is a single zero-cap calculation for a generic scenario, but anything like net debit cap, bond rating, and similar risk calculations can be accomplished by using lookup tables. On Dec 12, 6:45 am, KICI wrote: Not sure what the Zero Cap function is or where to find it? Please advise! Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| Excel 2002: Auto Sum function not working in large Excel file | Excel Discussion (Misc queries) | |||
| challenge! javascript function into excel function | Excel Worksheet Functions | |||
| Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
| Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions | |||
Hybrid Mode
