# Excel Formula

1. ## Excel Formula

Hello all Excel gurus. I've been trying to figure out how to do some equations in Excel for a few days but no success so far. So i found this forum maybe some of you can help me out

So I am a poker player and I am trying to do some calculations about EV(expected value). I am really just trying to calculate if a certain move has positive or negative EV.
I have one example for you.

So the formula is like this:
FOLD EQUITY Formula: EV = [EV(fold)] * x +[EV(call)] * (1-x)

EV(call)=-12.85
EV(fold)= 370
EV(total) = 370x-12.85(1-x)
EV(total) = 370x-12.85+12.85x
EV(total) = 382.85x-12.85
12.85 = 382.5x
x=12.85/382.85
X=3.4%

I can find out EV(call) and EV(fold) values thru other calculations and software. All i would like to do is to plug in the numbers into some excel cells and get the result.

notes: Ev(total)= 0 just so it does not bring any confusion.

I would be Extremly glad if somebody could help me out with this.

I attach my excel file

Cheers
Fish

2. Hi,

Unless I'm missing something, isn't it simply:

``Please Login or Register  to view this content.``
where call and fold are the cell reference locations of those two values.

Rgds

3. ## Seems to be working now

Yes sir damn that was easy. I tired a few examples and it seems to be correct.

Thanks for the help Sir.

Have a great weekend.

-Fish

4. Fish, hex, there's no need to quote whole posts in responding. It just occupies space.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1