Help with simple formula

F

fret_less

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
 
G

Gary''s Student

Very easy:

In A1 enter:
=150*.17

in A2 enter:
=A1+.34

copy the equation in A2 down as far as you want.
 
J

john the confused

Try putting in =I50*.17 , highlight that cell and the blank one below it then
use the fill handle.
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
D

David Biddulph

I think you've confused 150 with I50.

Instead try =OFFSET(I50,ROW()-1,0)*0.17 in row 1, and copy down.
 
D

David Biddulph

I had intended to say =OFFSET(I$50,2*(ROW()-1),0)*0.17 as I thought that the
OP was wanting to step down two rows in column I for every one row going
down in the formula, but the formula I gave will give the same result.
However looking at the original message again, I see that the OP wanted
blank rows between the formulae, so other suggestions posted are more
suitable.
 
Top