1 select the range of cells that you have applied this formula. To include more or fewer cells in a reference drag a corner of the border. Than paste it again into Replace with box but replace letters A with C in this box like shown below.
In the formula bar select the reference in the formula and then type a new reference.
For example to multiply the value in cell A2 by the value in B2 type this expression. Select the cell or range of cells that contains the formulas. Now click in field Replace with and type Sheet3 then click on Replace All button. To include more or fewer cells in a reference drag a corner of the border.