Formula / Equation help

Hello,

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:

=startingShare+((SaturationShareStartingShare)/(((1+((POWER(SaturationShare,2)/POWER(StartingShare,2)))/((HypergrowthStart+(TakeoverPeriod/2)-E43)/TakeoverPeriod)))))

InflectionShare+((SaturationShare-startingShare)/(((1+((POWER(SaturationShare,2)/POWER(StartingShare,2)))/((HypergrowthStart+(TakeoverPeriod/2)-currentperiod)/TakeoverPeriod)))))

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

{Re-posted as the image didn’t appear the first time around}

By: Jamie Lundahl

Leave a Reply

Your email address will not be published. Required fields are marked *