Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I'm struggling with an error on exponential computation and need an expert's help. One of my investment's holdings is minus. ^^;; When I tried to annualized the holding period yield, a minus number, it gives me an error sign #NUM!. Here is my formula I use. For ((Beg. Value / End. Value)-1)^(1/number of days) something like -7.59 % ^ (1/# of days) How do I get a right number in this case?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
X-axis exponential n^1.85 | Charts and Charting in Excel | |||
X-axis exponential n^1.85 | Charts and Charting in Excel | |||
exponential notation | Excel Discussion (Misc queries) | |||
Bi-Exponential Fit | Excel Discussion (Misc queries) | |||
Exponential configurations | New Users to Excel |