Help with formula
Hi Joe, thanks for the tip. Somehow I couldn't figure it out. Could you give
me a more specific step by step guide? I know, I am real stupid...
Much appreciated.
Josh
"JoeU2004" wrote:
"Jacob Skaria" wrote in message
...
1. Enter 72 in I3
2. Enter the below formula in I10
=I3-0.75
3. Select I4:I10. Drag the selection handle down as required....
Good answer. If dragging the selection down is a drag ;), you can enter the
target range into the Name Box (normally to the right of the Formula Bar in
Excel 2003), e.g. I4:I675, then paste (e.g. press ctrl+v).
----- original message -----
"Jacob Skaria" wrote in message
...
1. Enter 72 in I3
2. Enter the below formula in I10
=I3-0.75
3. Select I4:I10. Drag the selection handle down as required....
If this post helps click Yes
---------------
Jacob Skaria
"Josh W" wrote:
I am trying to create a formula whereby every seventh cell vertically
subtracts 0.75 from the previous amount, for example as follows:
I3=72
I10=71.25
I17=70.5
I24=69.75
I31=69
And so on all the way down. The cells in between are empty.
How do I acheive this? Many thanks!
|