Thread: Need help with a formula

Guys I would love some help.

I am in the process of working on an excel sheet to help me track my sports betting. I am trying to work on a formula that calculates the amount needed to risk to gain a certain reward.

So for instance if I type in th25at the Yanks are - 168 and I want to to win 25 dollars I must bet 25.

Currently I have the formula written like below.

=G7*E7/-100


And G7 is the Amount I want to win (So I have it at 25)

and E7 = the current line (-168)


This part seems to work fine
.

The problem is when I have a favorite like a team that is +168.
If I use this same formula it will say I need to bet -42 to win 25?


Can someone explain this please?

MAtt

Not sure if I'm fully understanding the significance of the + and - ahead of the 168, but if you are simply wanting to return a positive value, try using the IF formula.

=if((G7*E7/100)>0,(G7*E7/100),((G7*E7/100)*(-1)))

There is probably a simpler way of returning negative values as positive, but this is the best I can do

Try

=ABS((G7*E7)/-100)

that pretty much seemed to fix it when I tried various numbers in there, but I don't gamble on sports, so I don't know for sure that the outcome is correct, a few more examples would help me understand if this isn't working.

Maybe like this:

      ---A--- -B-- ---C---- ---D----
  1    Team   Line   Win      Bet   
  2   Yankees -168  $25.00   $42.00 
  3   Tigers   147  $25.00   $17.01

The formula in D2 and copied down is = IF(B2 < 0, - C2 * B2 / 100, C2 / B2 * 100)

Okay I got you now...
Basically, what you need to do is use an IF formula (IF the number is positive, use one calculation, if not, use another)

Try this:
=IF(E7>0,(G7/(E7/100)),(G7*E7/-100))