View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default 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