Thanks Jacob, I had huge problems finding my post. Somehow the notification
link received in my email box just opens a blank page in the communities
page, and I also don't know how to find all my posts in one place.

You solution was excellent! Simple and effective. I am embarrassed I
couldn't think of it...

"Jacob Skaria" wrote:

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!