K
KICI
Not sure what the Zero Cap function is or where to find it? Please advise!
Thanks
Thanks
R
ryguy7272
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---
'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---
K
KICI
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
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
R
Ron Rosenfeld
I'm not aware of any native Excel function with that name. Perhaps it is part
of an add-in.
--ron
I
ilia
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.
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.