Another easy fix for you geniuses here

New Contributor

Okay I see things being solved all the time that seem relatively easy, I am trying to get a few things to happen at once, and while I can figure out how to do them basically each separately I cannot seem to string them together as needed.  Any help would be much appreciated.

 

EFGHIJK 
Win/Lose?Wager/unitsOdds @ betPossible PayoutMoney Won/LostTotal PayoutTotal Bankroll 
W1-1104.554.55$9.55$109.55 
W11005.00#NAME?#NAME?#NAME? 

L

2

-220

4.554.5514.551.455 
  0#DIV/0!#DIV/0!#DIV/0!#DIV/0! 

 

A few explanations:

Column E,F,G are manual input (mandatory when in use)

Column H formula Returns as intended, however shows DIV error (I want that blank until input is i9n from other sources)

=IF(G2>1,'Totals Hidden'!$C$3*'Unit money'!F2*('Unit money'!G2/100), 'Totals Hidden'!$C$3*F2/(-G2/100))

Column I Returns properly when dealing with positive numbers only.

=SUM('Unit money'!C5*F4)+H4

I want to link this to Column F to return a negative result if F="L" and a positive result if F="W" and blank result is F="". (based on F*'Totals Hidden'!C3)

Column J should return 0.00 if the math is not done yet, or blank(Preferred). 

=IF(ISNA(I15),0,I15)+('Unit money'!F15*'Totals Hidden'!$C$3) - this is still only adding due to issue in Column I I believe

 

Column K should return bankroll total (IE Gains/Losses totals based on each gain or loss (with a base number to start) or blank if no math has been done. It is currently only repeating column I on each line due to that error, and not totaling a +- based on win/loss

 

 

I know this is a lot, but I learn be reading/doing  and so it will help a lot in future endeavors.

attached is current status of spreadsheet

Best.

 

 

 

1 Reply

@DMills74 

Does the attached version do what you want?