Hi

I need to make a cumulative calculation using the following figures.

Number of transactions
52
71
34
87
96

For the first 100 transactions I will be charged $300, from 101 - 200 it will be $275, and for 201+ it will be $250.

I need to populate the figure in each line so I can subtotal at the end.

Any help would be great.