# how to calculate fixed one cell to many cells by using formula

0

how to calculate fixed one cell to many cells by using formula?

How to calculate the value of a single cell from the cell value of the different columns by formula?

for exp.: i want multiply cell "A1" to any column's cell value, but repeat above cell A1

=B1*A1

=B3*A1

=B5*A1

=B7*A1

what formula this condition?

Shall I then copy paste the formula in the cell of the fold.

pl z guide me.

## Answers

0
Selected Answer

I believe that you may be looking for an Absolute Reference? if in your formula you hit the F4 key that will turn on absolute references.  In your example, I would...type the "=" then point to cell B1, then use the asteric " * " for the multiplication, then point to cell A1 and hit the F4 key one time (this will place dollar signs "\$" before the row and Column)  the completed formula would look like = B1 * \$A\$1    which could e copied to another cell and it would always reference A1 in the formula.   Please look at Excel's help or google Absolute and Relative cell references for additional info (and probably a better explanation ~ but that is the best way to learn it too!)

### Discussion

thank you for this help. i will try this shortly. thanks again.
lakhendra (rep: 2) Nov 18, '16 at 6:05 am