Formula Help
 

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

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

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


--
babz
------------------------------------------------------------------------
babz's Profile: http://www.excelforum.com/member.php...o&userid=27810
View this thread: http://www.excelforum.com/showthread...hreadid=493074

Formula Help
 

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

Vaya con Dios,
Chuck, CABGx3




"babz" wrote:


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

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

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


--
babz
------------------------------------------------------------------------
babz's Profile: http://www.excelforum.com/member.php...o&userid=27810
View this thread: http://www.excelforum.com/showthread...hreadid=493074

Formula Help
 

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)


In article ,
babz wrote:

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

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

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

Formula Help
 

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 he
http://www.editteach.org/documents/W...ercentages.pdf




"babz" wrote:


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

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

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


--
babz
------------------------------------------------------------------------
babz's Profile: http://www.excelforum.com/member.php...o&userid=27810
View this thread: http://www.excelforum.com/showthread...hreadid=493074

Formula Help
 

Thank you both - you are lifesavers!


--
babz
------------------------------------------------------------------------
babz's Profile: http://www.excelforum.com/member.php...o&userid=27810
View this thread: http://www.excelforum.com/showthread...hreadid=493074