| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Linear Mode
