| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Word Wrap Problem within cell | Excel Discussion (Misc queries) | |||
| syntax question - cell references in VB code | New Users to Excel | |||
| Cell formatting behaviour question | Excel Discussion (Misc queries) | |||
| cell in cell - 2nd question | Excel Discussion (Misc queries) | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Linear Mode
