Formula / equation help

[JamieL]

Hello,<o></o>

I am trying to replicate the formula below in excel, but can't quite get it right. The aim is to use the formula to help drive data that I can graph into an s-shaped sales curve. The formula I have is:<o></o>

=Startingshare+((SaturationShare-startingShare)/(((1+((POWER(SaturationShare,2)/POWER(StartingShare,2)))/((HypergrowthStart+(TakeoverPeriod/2)-currentperiod)/TakeoverPeriod)))))<o></o>

Would anyone mind having a look and tell me if I'm missing something obvious please?

 

[offthelip]

I think you have missed out a "power" so it should be something like thisL
=Startingshare+((SaturationShare-Startingshare)/(((1+POWER(((POWER(SaturationShare,2)/POWER(Startingshare,2))),((HypergrowthStart+(TakeoverPeriod/2)-currentperiod)/TakeoverPeriod))))))

I am not sure I have got the brackets right since I can't test it easily

 

[Anthony47]

From what I see, B is the base of a power and E is it exponent. So the denominator should be calculated as
1+B^E

My guess is that the formula is

=Startingshare +(SaturationShare-Startingshare)/(1+(SaturationShare^2/Startingshare^2)^((HypergrowthStart+TakeoverPeriod/2-currentperiod)/TakeoverPeriod))

I used the operator "^" rather then the function POWER, to calculate powers.

Bye