Fill Right |
We can also fill right. We must select the original cell (and the cells to the right) and select from the Edit menu -- Fill and Right.
|
If we were to fill right from A1 to C1 we would get the formulas displayed to the left. Notice that the second part of the equation is FIXED or (ABSOLUTE REFERENCE "$ sign" so always references B3 which is 10). |
Answers would be A1=16, B1=12, C1=15.