Help with simple formula
I think you've confused 150 with I50.
Instead try =OFFSET(I50,ROW()-1,0)*0.17 in row 1, and copy down.
--
David Biddulph
"Gary''s Student" wrote in message
...
Very easy:
In A1 enter:
=150*.17
in A2 enter:
=A1+.34
copy the equation in A2 down as far as you want.
"fret_less" wrote:
My formula is very simple. All it entails is =I50*.17 The next formula
would
be =I52*.17..... and so on 54, 56, 58, etc. I don't want to have to
manually
enter every cell's formula with the appropriate #. Is there any way to
get
Excel to recognize the pattern and know that 2 cells down I am going to
enter
the formula again? I figure if I can think this up than it can be done.
Thanks a million!!
Nick
|