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!

	A	B	C
1	Income	$1,000.00
2
3	Expense Item	Amount	% of Income
4	Cost 1	$100.00	10%
5	Cost 2	$125.00	?
6	Cost 3	$150.00	?
7	Cost 4	$200.00	?

<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>

 

[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...