confusion with 'greater than >' formula & result

Hi folks, i was wondering if any of you could help me with a little problem i have stumbled across.

I do not venture into the World of excel very often so please be patient as i try to explain

Here is the table i am trying to maintain.
\1

We will focus on Row 3
Column B is basically 550 points + column C = Base Roll.
We need to introduce a cap so no more than 1000 points can be displayed/earned. So column G adds all points & column F caps.
So far it's all ok.
Now when i add a value to column E (points spent) those points are deducted from column G instead of the capped 1000.
Entering a value of 500 displays 800 in column F instead of 500.

The formulas i am using
D

Please Login or Register  to view this content.

F

Please Login or Register  to view this content.

G

Please Login or Register  to view this content.

Any ideas where i am going wrong or any pointers?

Much appreciated

Neen

Welcome to Exceltip forum

Please take a couple of minutes and read ALL the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1) so that it better discribes your problem/request

to cap something use
=min(your sum,1000) now whatever your sum is the most it can be is 1000

you said formula in col f is

=IF(G3 > 1000, "1000",G3)
so where is this value deducted from 1300 fit in with that formula?
cant see that from an image post the workbook

post the workbook!

Maybe you could just post it here ...

Following Martin's suggestion, in G2 and down, = MIN(1000, 100*B2 + C2 - E2)