Thread: Exponential
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
escapeman escapeman is offline
external usenet poster
 
Posts: 2
Default Exponential

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??