MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula for Baccarat Commissions


Posted by Ron on February 17, 2001 7:23 PM

Can anyone help me with a formula for commissions testing Baccarat..... I want to figure it in units and I use the following formula within 1 column and it works for that but I am net betting between 2 columns..
=+SUMIF(G2:G78,">0")*0.05

P B
-2 1 Ignore
1 -2 Loss- disregard as no commision on a loss
-3 2 Ignore a B won but net bet was -1 on P
-1 1 B won but no bet
1 2 Bet won with a net bet of 1

I only want it to count the positive number in the B column minus the P #if it exceeds the number in the P column and take that number times .05 as in formula above..

Last line above:
IE: 2-1 = 1 *.05 = .05 Units for commission

Negative numbers are irrelavant in the B Column


Posted by Aladin Akyurek on February 18, 2001 1:52 AM

Not quite sure (i don't know a thing about Baccarat), but here we go:

I assume the entries (including labels P and B) to occupy the range A1:B6, array-enter (that is, hit control+shift+enter at the same time to enter) the following formula

C2 =(B2:B6>0)*((B2:B6)+(A2:A6)>0)*(((B2:B6)-(A2:A6))*0.05) [ copy down as far as needed ]

Aladin