| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fixed cell in formula calculation
i am trying to create a repeating formula, but use a single cell as a
constant, e.g. Col A Col B Col C Row 1 3 3 =(a1*b1)+b4 Row 2 2 3 =(a2*b2)+b4 Row 3 4 2 =(a3*b3)+b4 Row 4 2 in this case b4 is constant in all formulas, while the other variables (a1 & b1, etc.) naturally adjust when the column is autofilled. My problem is in a typical autofill, b4 will change to b5 to b6, etc. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
fixed cell in formula calculation
use
=(a1*b1)+$b$4 and copy that down. The $ before the B says keep the column static, while the $ before the 4 means keep the row static "mattg" wrote: i am trying to create a repeating formula, but use a single cell as a constant, e.g. Col A Col B Col C Row 1 3 3 =(a1*b1)+b4 Row 2 2 3 =(a2*b2)+b4 Row 3 4 2 =(a3*b3)+b4 Row 4 2 in this case b4 is constant in all formulas, while the other variables (a1 & b1, etc.) naturally adjust when the column is autofilled. My problem is in a typical autofill, b4 will change to b5 to b6, etc. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
fixed cell in formula calculation
Thanks for your help!
"Duke Carey" wrote: use =(a1*b1)+$b$4 and copy that down. The $ before the B says keep the column static, while the $ before the 4 means keep the row static "mattg" wrote: i am trying to create a repeating formula, but use a single cell as a constant, e.g. Col A Col B Col C Row 1 3 3 =(a1*b1)+b4 Row 2 2 3 =(a2*b2)+b4 Row 3 4 2 =(a3*b3)+b4 Row 4 2 in this case b4 is constant in all formulas, while the other variables (a1 & b1, etc.) naturally adjust when the column is autofilled. My problem is in a typical autofill, b4 will change to b5 to b6, etc. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What calculation can I use to find income on a fixed investment? | Excel Discussion (Misc queries) | |||
| how to paste formula but reference a fixed cell | Excel Discussion (Misc queries) | |||
| Problem with draging a formula,one cell value fixed,trivial question | Excel Discussion (Misc queries) | |||
| Need formula for a fixed cell minus last entry on ongoing log | Excel Worksheet Functions | |||
| Fixed Duration-strange calculation | New Users to Excel | |||
Hybrid Mode
