Ya, in your case you can use the formula:

<Current Year Sales = <Last Years Sales * (1+<percentage change)

With variables located within <. Just solve for any variable you are
trying to find given you know the other 2. Note that if you have a decrease
in percentage you use a negative number for <percentage change

--
David Billigmeier


"Dan" wrote:

Thanks, this is great!

Formula : =3700/(100%-11.60%)
Formula : 4500/151%

Is there one general formula to use for both scenerios, so I wouldn't
have to differentiate between positive and negative changes?