Why does copying my Excel formula change the cell holding our kit multiplier?
TechnologyI'm calculating materials for craft kits. Each row has the quantity needed for one kit in column B, and F1 holds the number of kits we're making. My first formula is `=B2*F1`.
The first answer is right. After I fill it down, the formulas refer to F2, F3 and so on, although the multiplier is still in F1. Microsoft's guidance explains that relative references change when copied, while absolute references stay fixed. Excel's reference guidance
How should I set this up so the material row changes but the kit-count reference doesn't? I want to understand the copied formula rather than type the same multiplier into every line.