Excell Help Please

[beton]

Can one of you expert excell gurus please help me with the following.

I am trying to put the retirement staking plan on excell. I have as a primary target $600 (divsor 6 thus min bet $100) I have this in col C. In colD I have my losses. This is from col M which is the profit and loss col. Thus my formula in col D is =-M4. ColE is the total of colC +ColD formula =C5+C5. At present this offsets all profit and losses in colM into my total target instead of the desired stop when previous losses are recouped.

My formula for col D should in fact be =-M4 if <0 use 0. How I can I effect this I've played with it for hours and I concede defeat The computor has been saved two inches from the floor several times.

I thank you in advance
Regards Beton

[beton]

OOps just had another look at this. It is col E that this should occur thus it should have the formula =C4+D4 if <600 use 600 Again how can I achieve this?

Thanks again Beton

[jose]

Beton, I don't know if it will help but in an old post there is a copy of this staking plan, which is on an Excel spreadsheet.
I shall go back thru for you and see if I can find it if you like.

[Zlotti]

Can one of you expert excell gurus please help me with the following.

I am trying to put the retirement staking plan on excell. I have as a primary target $600 (divsor 6 thus min bet $100) I have this in col C. In colD I have my losses. This is from col M which is the profit and loss col. Thus my formula in col D is =-M4. ColE is the total of colC +ColD formula =C5+C5. At present this offsets all profit and losses in colM into my total target instead of the desired stop when previous losses are recouped.

My formula for col D should in fact be =-M4 if <0 use 0. How I can I effect this I've played with it for hours and I concede defeat The computor has been saved two inches from the floor several times.

I thank you in advance
Regards BetonI have the plan you are looking for but I can't uplaod to this part of the forum... no idea why! Email me 'retireme at mailup dot net' and I will forward.

If your system produces the odd long run of outs then maybe another type of staking plan is better. As I said drop me a line and I will send a few different ones for you to peruse.

Regards

Zlotti

[Wunfluova]

Hi Beton,

Put this formula in cell E4
=IF(C4+D4<600,600,C4+D4)

Regards,
Wun

[beton]

Thanks that seems to do the trick I'll start loading my data tommorrow
regards Beton