Calc question.

[Shane-01]

(A table:)

Odds    Stake   W/L  Profit-2%C W/L        £500.00

1.38	£25.00	0	 £64.47	 -£25.00	£475.00
1.40	£23.75	1	 £58.19	  £58.19	£533.19
1.49	£26.66	1	 £53.32	  £53.32	£586.51
1.41	£29.33	0	 £70.10	 -£29.33	£557.18
1.26	£27.86	0	 £105.01 -£27.86	£529.32
1.45	£26.47	1	 £57.64	  £57.64	£586.96
1.50	£29.35	1	 £57.52	  £57.52	£644.48
1.34	£32.22	0	 £92.88	 -£32.22	£612.26
1.44	£30.61	1	 £68.18	  £68.18	£680.44
1.31	£34.02	0	 £107.55 -£34.02	£646.42

Hi all. The example above should give you an idea of what I am having trouble with.

In the 1st W/L column cells are 0’s and 1’s and they represent a value of either won or lost.

What I am trying to do is when a zero is in the 1st W/L column cell, whatever STAKE value it is, it appears in the 2nd W/L column cell as a minus value.

And when a 1 is in the 1st W/L column cell, the Profit-2%C column cell appears in the 2nd W/L column cell as a plus value.

I am having to do this manually but I have managed to do all the other calculations.

I thank you for your time.

Kind Regards

(Edited for better readability by @Lupp )

[Shane-01]

Thank you @Lupp for editing. I did copy and paste it from libreoffice but it came out all over the place.

Thank you again.

[erAck]

You can use the CHOOSE function.

=CHOOSE(C3+1;-B3;D3)

[Shane-01]

Thank you very much. Much appreciated.

[anon73440385]

Hello,

you may use: =IFS(C3=0;-B3;C3=1;D3;TRUE();"") in second W/L column (example for row 3 being the first data row) - See also the following sample file: PlusMinusStake.ods

Hope that helps.

[Shane-01]

Thank you, Opaque. The example you sent me is brilliant. Thank you again for your time.