P
Peter McCaul
My apologies. I posted this question yesterday and the response didn't work
(or I don't have the knowledge to make it work). Regardless, I will post
again and I'm hoping someone can help me out.
I am setting up a Lotto chart for work. The game we're playing is Keno and
there's a daily draw. The initial investment is $250.
Column A: Will have the daily investment.
Column B: Will have the winnings.
Column C: Will have the losses.
Column D: Will have the actual amount that's left from the initial
investment and it will take into consideration the win or loss for that day
and also the amount from the day before. For example; If the day before we
have $230 in column D. Then the current day will take the total of column D
(the day before), subtract the daily investment and either add or subtract
the win or loss respectively.
May someone help me with this formula? I would greatly appreciate it.
Thanks to Jan who sent me =$A$2+SOM($B$2:B2)-SOM($C$2:C2) but once again, I
couldn't get this to work.
(or I don't have the knowledge to make it work). Regardless, I will post
again and I'm hoping someone can help me out.
I am setting up a Lotto chart for work. The game we're playing is Keno and
there's a daily draw. The initial investment is $250.
Column A: Will have the daily investment.
Column B: Will have the winnings.
Column C: Will have the losses.
Column D: Will have the actual amount that's left from the initial
investment and it will take into consideration the win or loss for that day
and also the amount from the day before. For example; If the day before we
have $230 in column D. Then the current day will take the total of column D
(the day before), subtract the daily investment and either add or subtract
the win or loss respectively.
May someone help me with this formula? I would greatly appreciate it.
Thanks to Jan who sent me =$A$2+SOM($B$2:B2)-SOM($C$2:C2) but once again, I
couldn't get this to work.