M
M. Mansoor Jamal
Hi there,
I have a bit of a problem:
Suppose I have certain values (numbers) from A3 to A 300
Now in cell B5, I have the formula, = (A3 * A5).
And then in cell B6, I have the formula = (A5 * A7).
The problem is I cannot do a drag and drop since it increases cell values by
1.
I need to fill cells B5 - B50 starting with the formula A3 * A5 and the next
one with A5 * A7, i.e. incrementing cells by two instead of the default one.
Does anyone know if this is doable in excel, and if yes, then how please.
Thank you!
I have a bit of a problem:
Suppose I have certain values (numbers) from A3 to A 300
Now in cell B5, I have the formula, = (A3 * A5).
And then in cell B6, I have the formula = (A5 * A7).
The problem is I cannot do a drag and drop since it increases cell values by
1.
I need to fill cells B5 - B50 starting with the formula A3 * A5 and the next
one with A5 * A7, i.e. incrementing cells by two instead of the default one.
Does anyone know if this is doable in excel, and if yes, then how please.
Thank you!