How can I script formula?

S

Sam

Here is what I am trying to do
Cell B=A*2+18+3 Then C=B*2 without pointing to specific cells such as A1, A2
ect.

I'm hoping i can automate it so it uses whatever row it is on for the
equation instead of requiring me to point to specific Cells for the
calculation to work.
Any help or advice is greatly appreciated thanks.
 
R

Roger Govier

Hi Sam

Not too sure what you mean here.
If in cell B1 you enter
=A1*2+18+3
Then as you copy it down the column it would change automatically to
=A2*2+18+3, =A3*2+18+3 etc.
If you copy across it will change to
=B1*2+18+3 = C1*2+18+3

This is because the references are all relative.
You can make the Column an Absolute reference by putting a $ sign in
front of it
=$A1*2+18+3 where the column won't change as you copy across, but the
row would change as you copy down.
Conversely you can make the Row reference Absolute by prefixing with a $
sign
=A$1*2+18+3 where the column will alter as you copy across but the row
will be fixed.

Finally, prefixing both column and row with $ sign fixes the cell to be
absolute and it won't change at all as you copy down or across
=$A$1*2+18+3

Is this what you meant? If not post back with more detail of what you
want.
 
S

Sam

I actually figured it out a few minutes after I posted the question.
What I was looking for was the Highlight columns and Control enter so that
it would automate the calculation for every row I highlight without having to
point to A1, A2, A3 ect for each new row.
I appreciate the help and have a wonderful day.
 
Top