Help with progression cells

[Davebro]

I am trying to create the Stake in column A
If column C shows L then keep stake the same
If column W increase the stake by 5
If W and highest amount so far in Column B then decrease stake to 5.
I have been using ifs and max but can't seem to get it quite right.

Stake	Total	Position	(Comment)
5	.5.00	L	Loss unchanged stake
5	3.64	W	Win so increase stake
10	-6.36	L	Loss - unchanged stake
10	-16.36	L	Loss. unchanged stake
10	-1.54	W	Win so increase stake
15	22.47	W	Highest Amount so far
5	28.27	W	Decrease stake
10	18.27	L	Loss- unchanged stake
10	42.02	W	Highest Amount so far
5	37.02	L	Decrease stake
5	32.02	L	Loss - unchaneed stake
5	38.38	W	Win so increase stake
10	28.38	L	Loss. unchanged stake
10	18.38	L	Loss - unchanged stake
10	8.38	L	Loss - unchanged stake
10	.1.62	L	Loss- unchanged stake
10	-11.62	L	Loss- unchanged stake
10	-21.62	L	Loss- unchanged stake
10	9.73	W	Win so increase stake
15	-5.27	L	Loss - unchanged stake
15	-20.27	L	Loss - unchanged stake
15	-35.27	L	Loss - unchanged stake
15	-18.74	W	Win so increase stake

 

[DanteAmor]

How about:

Libro1
	A	B	C	D	E
1	Stake	Total	Position	(Comment)	Resutl
2	5	5.00	L	Loss unchanged stake	5
3	5	3.64	W	Win so increase stake	10
4	10	-6.36	L	Loss - unchanged stake	10
5	10	-16.36	L	Loss. unchanged stake	10
6	10	-1.54	W	Win so increase stake	15
7	15	22.47	W	Highest Amount so far	10
8	5	28.27	W	Decrease stake	0
9	10	18.27	L	Loss- unchanged stake	10
10	10	42.02	W	Highest Amount so far	5
11	5	37.02	L	Decrease stake	5
12	5	32.02	L	Loss - unchaneed stake	5
13	5	38.38	W	Win so increase stake	10
14	10	28.38	L	Loss. unchanged stake	10
15	10	18.38	L	Loss - unchanged stake	10
16	10	8.38	L	Loss - unchanged stake	10
17	10	1.62	L	Loss- unchanged stake	10
18	10	-11.62	L	Loss- unchanged stake	10
19	10	-21.62	L	Loss- unchanged stake	10
20	10	9.73	W	Win so increase stake	15
21	15	-5.27	L	Loss - unchanged stake	15
22	15	-20.27	L	Loss - unchanged stake	15
23	15	-35.27	L	Loss - unchanged stake	15
24	15	-18.74	W	Win so increase stake	20
Hoja3

Cell Formulas
Range	Formula
E2:E24	E2	=IF(C2="L",A2,IF(MAX(B$2:B2)=B2,A2-5,A2+5))

Or this:

=A2+IF(C2="L",0,IF(MAX(B$2:B2)=B2,-5,5))

 

[Davebro]

How about:

Libro1
	A	B	C	D	E
1	Stake	Total	Position	(Comment)	Resutl
2	5	5.00	L	Loss unchanged stake	5
3	5	3.64	W	Win so increase stake	10
4	10	-6.36	L	Loss - unchanged stake	10
5	10	-16.36	L	Loss. unchanged stake	10
6	10	-1.54	W	Win so increase stake	15
7	15	22.47	W	Highest Amount so far	10
8	5	28.27	W	Decrease stake	0
9	10	18.27	L	Loss- unchanged stake	10
10	10	42.02	W	Highest Amount so far	5
11	5	37.02	L	Decrease stake	5
12	5	32.02	L	Loss - unchaneed stake	5
13	5	38.38	W	Win so increase stake	10
14	10	28.38	L	Loss. unchanged stake	10
15	10	18.38	L	Loss - unchanged stake	10
16	10	8.38	L	Loss - unchanged stake	10
17	10	1.62	L	Loss- unchanged stake	10
18	10	-11.62	L	Loss- unchanged stake	10
19	10	-21.62	L	Loss- unchanged stake	10
20	10	9.73	W	Win so increase stake	15
21	15	-5.27	L	Loss - unchanged stake	15
22	15	-20.27	L	Loss - unchanged stake	15
23	15	-35.27	L	Loss - unchanged stake	15
24	15	-18.74	W	Win so increase stake	20
Hoja3

Cell Formulas
Range	Formula
E2:E24	E2	=IF(C2="L",A2,IF(MAX(B$2:B2)=B2,A2-5,A2+5))

Or this:

=A2+IF(C2="L",0,IF(MAX(B$2:B2)=B2,-5,5))

Many thanks, I may not have explained it to clearly, I want the stake in column E to be the same as Col A
but Column A is for guidance only.

 

[DanteAmor]

Many thanks, I may not have explained it to clearly, I want the stake in column E to be the same as Col A
but Column A is for guidance only.

You could put the results you expect in column E, again explaining each possible case; Or column A are the results?


Why does cell A2 start with 5?

Or the value in column A already exists and you want the same value in the same column A to be modified?

 

[Davebro]

Hi again, First stake was 5 which Lost
If I use =IF(C2="L", E2, IF(C2="W", IF(B2=MAX(B$2:$B2), 5, E2+5), E2))
This seems to work for me.
Many thanks for your help.