How to keep referencing cell while dragging formula?

[tonynguyen10]

Hello,

I would like to be able to drag the cell from C3 all the way down to C7 and still retain the formula on income / amount equals percentage.

In other words, $100 / $1,000 is 10%. When I drag cell C3 down to C4, it changes the formula to $125 / BLANK = #DIV/0!.

How can I set the formula it divides everything by $1,000 as i drag down the C column?

Thank you!


[TABLE="width: 283"]
<colgroup><col><col span="2"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Income[/TD]
[TD]$1,000.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Expense Item[/TD]
[TD]Amount[/TD]
[TD]% of
Income[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Cost 1[/TD]
[TD]$100.00[/TD]
[TD]10%[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Cost 2[/TD]
[TD]$125.00[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Cost 3[/TD]
[TD]$150.00[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Cost 4[/TD]
[TD]$200.00[/TD]
[TD]?[/TD]
[/TR]
</tbody>[/TABLE]

 

[Michael M]

Make b1 an Absolute reference ....not the dollar signs in the formula

Excel 2007
	A	B	C
1	Income	$1,000.00
2	Expense Item	Amount	% of income
3	Cost 1	$100.00	10%
4	Cost 2	$125.00	13%
5	Cost 3	$150.00	15%
6	Cost 4	$200.00	20%
Sheet1

Cell Formulas
Range	Formula
C3	=B3/$B$1
C4	=B4/$B$1
C5	=B5/$B$1
C6	=B6/$B$1

 

[szymagic]

I think you are looking for this:

=B4/$B$1

Put that in C4 and drag down

 

[tonynguyen10]

Thank you kind stranger - that solved my problem!

Thanks again!

 

[tonynguyen10]

I think you are looking for this:

=B4/$B$1

Put that in C4 and drag down

Thank you as well!!

 

[Michael M]

Glad to help...