Problem with draging a formula,one cell value fixed,trivial question
 

Hi.

I have a value in cell A10. Then i have a formula in cell C1 which
goes: (A1+B1)/A10. If I drag the formula down to cell C5 the formula
for C2 will be (A2+B2)/A11,
for C3 will be (A3+B3)/A12,....,for C5 will be (A5+B)/A14.
I would like the formula to have the A10 parameter fixed so when i drag
the formula down the A10 would always be A10(it wouldn't go up by 1).
So the formula for C2 will be (A2+B2)/A10,
for C3 will be (A3+B3)/A10,....,for C5 will be (A5+B5)/A10. Please
help.
Thanks,

Marko

Problem with draging a formula,one cell value fixed,trivial question
 

make your original in C1 formula
=(A1+B1)/A$10
then drag down.
See help on absolute versus relative references.

Regards
Rowan

marko wrote:
Hi.

I have a value in cell A10. Then i have a formula in cell C1 which
goes: (A1+B1)/A10. If I drag the formula down to cell C5 the formula
for C2 will be (A2+B2)/A11,
for C3 will be (A3+B3)/A12,....,for C5 will be (A5+B)/A14.
I would like the formula to have the A10 parameter fixed so when i drag
the formula down the A10 would always be A10(it wouldn't go up by 1).
So the formula for C2 will be (A2+B2)/A10,
for C3 will be (A3+B3)/A10,....,for C5 will be (A5+B5)/A10. Please
help.
Thanks,

Marko

Problem with draging a formula,one cell value fixed,trivial question
 

Thanks a million!
It's those little things that make me happy!! :)
Thanks again!

Marko from Croatia

Problem with draging a formula,one cell value fixed,trivial question
 

You're welcome!!

marko wrote:
Thanks a million!
It's those little things that make me happy!! :)
Thanks again!

Marko from Croatia