Formula Help

[babz]

I need help with a formula. I can't figure out how to calculate for
missing number.

'05 we sold x units, I know we had a X% increase over '04 so what wa
the '04 sales?

Column A = '05
Columb B = '04
Column C = % increas

 

[CLR]

'04 sales = '05 sales / 1.X% increase

Vaya con Dios,
Chuck, CABGx3

 

[JE McGimpsey]

One way:

B1: =A1 / (1+C1)

This assumes that by "% increase" you mean that C1 has a value of, say,
20% or 0.2. If instead it's 20, use

B1: =A1 / (1 + C1/100)

 

[Scott Wagner]

OK open a blank worksheet and follow steps below.

in cell A1 enter 110
in cell c1 enter 10%
in cell b1 enter this formula =A1/(C1+1)

That should work.

Read more about how this works mathmatically here:
http://www.editteach.org/documents/WorkingWithPercentages.pdf

 

[babz]

Thank you both - you are lifesavers