Okay, so the thing is.
I'm making a sheet for me and some friends where we bet on football
So I would like values to go into a certain cell but only if the bet is won.

So I have a table with names, potential outcome, Win or Loss

on my frontpage I have the total amount of money gambled and then i would like that subtracted for the amount of money the given person has won, but ONLY if the bet is won. How do i do that?

How do I make a cells value dependant on a number of factors?