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