What should the formulas be?

[itzzjason]

	A	B	C	D	E	F	G	H	I
1	Players	Buy-in (cash)	Buy-in (credit)	Ending Stack Size	Profit/Loss	Deduct Chips From Stack due to credit	Owes Cash	Cash Out
2	Player 1	$ 0	$ 200	$ 0	-200		200
3	Player 2	$ 0	$ 200	$ 150	-50	150	50
4	Player 3	$ 100	$ 0	$ 455	355			455
5	Player 4	$ 0	$ 400	$ 0	-400		400
6	Player 5	$ 0	$ 500	$ 770	270	500		270
7	Player 6	$ 100	$ 200	$ 0	-300		200
8	Player 7	$ 100	$ 200	$ 270	-30	200		70
9	Player 8	$ 100	$ 0	$ 725	625			725

I act as the "banker" for the occasional private poker game between my friends and I. The above spreadsheet/table is a sample result of one of our games. I hope the table is self-explanatory. If not, then I can provide more context/details.

I was wondering - What formulas can go in Columns F, G, and H to automatically calculate to get those numbers?

The formulas that I was trying to compose would work in a few cells but not be correct in another cell.

 

[steve the fish]

Looks like this:

=SUM(B2,C2,E2,-H2)
=-MIN(0,B2+E2)
=MAX(0,B2+E2)

 

[itzzjason]

Looks like this:

=SUM(B2,C2,E2,-H2)
=-MIN(0,B2+E2)
=MAX(0,B2+E2)

That didn't work for me

 

[steve the fish]

Then make your numbers real numbers. If you want $ in there use formatting.

 

[itzzjason]

Then make your numbers real numbers. If you want $ in there use formatting.

Sorry, I meant the formulas you provided was giving me incorrect answers. I do type in numbers only then format the cells to include the $ sign

 

[horrellbt01]

Try This

A	B	C	D	E	F	G	H
Players	Buy-in (cash)	Buy-in (credit)	Ending Stack Size	Profit/Loss	Deduct Chips From Stack due to credit	Owes Cash	Cash Out
Player 1	0	-200	0	=B3+C3+D3	=ABS(IF(D3=0,0,IF(C3=0,0,IF(E3>0,D3-E3,IF(E3<0,C3-E3,C3+E3)))))	=IF(E3<0,E3-B3,0)	=IF(G3=0,E3-B3,0)
Player 2	0	-200	150	=B4+C4+D4	=ABS(IF(D4=0,0,IF(C4=0,0,IF(E4>0,D4-E4,IF(E4<0,C4-E4,C4+E4)))))	=IF(E4<0,E4-B4,0)	=IF(G4=0,E4-B4,0)
Player 3	100	0	455	=B5+C5+D5	=ABS(IF(D5=0,0,IF(C5=0,0,IF(E5>0,D5-E5,IF(E5<0,C5-E5,C5+E5)))))	=IF(E5<0,E5-B5,0)	=IF(G5=0,E5-B5,0)
Player 4	0	-400	0	=B6+C6+D6	=ABS(IF(D6=0,0,IF(C6=0,0,IF(E6>0,D6-E6,IF(E6<0,C6-E6,C6+E6)))))	=IF(E6<0,E6-B6,0)	=IF(G6=0,E6-B6,0)
Player 5	0	-500	770	=B7+C7+D7	=ABS(IF(D7=0,0,IF(C7=0,0,IF(E7>0,D7-E7,IF(E7<0,C7-E7,C7+E7)))))	=IF(E7<0,E7-B7,0)	=IF(G7=0,E7-B7,0)
Player 6	100	-200	0	=B8+C8+D8	=ABS(IF(D8=0,0,IF(C8=0,0,IF(E8>0,D8-E8,IF(E8<0,C8-E8,C8+E8)))))	=IF(E8<0,E8-B8,0)	=IF(G8=0,E8-B8,0)
Player 7	100	-200	270	=B9+C9+D9	=ABS(IF(D9=0,0,IF(C9=0,0,IF(E9>0,D9-E9,IF(E9<0,C9-E9,C9+E9)))))	=IF(E9<0,E9-B9,0)	=IF(G9=0,E9-B9,0)
Player 8	100	0	725	=B10+C10+D10	=ABS(IF(D10=0,0,IF(C10=0,0,IF(E10>0,D10-E10,IF(E10<0,C10-E10,C10+E10)))))	=IF(E10<0,E10-B10,0)	=IF(G10=0,E10-B10,0)

Be sure to register the Buy In Credit as a negative number

 

[steve the fish]

Sorry, I meant the formulas you provided was giving me incorrect answers. I do type in numbers only then format the cells to include the $ sign

I wouldnt have posted it if i hadnt checked it produced the same as your example.