Making a gambling spreadsheet

Hey... thanks...

it's Total=Total+$ lost or won on the bet



I want to make it so, what I type in the $ won or lost in one column and make it automatically add to the running table in the next column as shown:


Win/Loss$ Total
20--------5000
-50-------5020
800-------4970
30--------5770
-500------5800
-----------5300

Actually this is exactly what I wanted! Only problem is I have some other equations involving the K column and in place of the equation I get "#VALUE!" now. Which makes sense because K is blank until the total gets there.

I've got one more hard one, that's not too important. The sheet is functional as is now But I had to make 2 columns because there are 2 equations depending on if my pick is the favorite or the underdog. American odds are posted like this:

These equations show me what my winnings would be if I won the bet.

G:G=wager C:C=odds

Favorite---Fighter A : -250 G:G*-1*(100/C:C)
Underdog--Fighter B : +160 G:G*(C:C/100)




Is there some way to have one expression that says something to the effect of "if number in C:C is positive then use G:G*(C:C/100)... if number in C:C is negative use G:G*-1*(100/C:C) so I don't have to have 2 columns?