Forum Discussion
Excel add same formula easy way
Hello, I have numbers in C1 till Z1 cells. I would like to multiply these cells value with A1 value. Example: +A1*C1, +A1*B1......+A1*Z1 I know I could write one by one. But is there a simple w...
Hi there,
For this purposes, using absolute references will help. All you have to do is to fix a cell (named as absolute reference) by writing its reference as $A$1. In this way, you are fixing both the column and the row of that reference.
Then, use =$A$1*C1 to perform your desired calculation and lastly fill this formulation to the right to fill until Z1. Being the cell A1 fixed, it will not change as you drag the formula. C1 will naturally change as you are dragging to the right, so it will basically change from C1 to D1 to E1...
See attached workbook for illustration.
Martin
Hi all,
First of all thank you for your response.
Those answers are not good, because you put the solution to C2-Z2.
The solution have to be C1-Z1. Where the numbers are.
The original numbers have to change.
So, when A1 value is 1 it shows which are the basic numbers.
This is why I have to add the formula to the original cells.
First of all thank you for your response.
Those answers are not good, because you put the solution to C2-Z2.
The solution have to be C1-Z1. Where the numbers are.
The original numbers have to change.
So, when A1 value is 1 it shows which are the basic numbers.
This is why I have to add the formula to the original cells.