Change true/false

[Andrew]

I am trying to find out how to change true/false to won/lost.
E1=stake
F1=odds
I1=Winnings
J1=balance
K2=Results
I would like to enter into K2 - Won or lost, rather than True or false
formula is something like this K2 is J2+I2 if WON, if Lost J2-I2

Many thanks for your help

 

[John Wilson]

Andrew,

Not sure from your post exacltly what you want to do.
Would be helpful if you posted the formula that you're using.

Just guessing here, but if your balance is greater than your
winnings, you "won" and if it's less, you "lost"??

In K2.....
=IF(J2>I2,"Won","Lost")

If that's not it, post back.

John

 

[Andrew]

This is how the table is laid out

J2=Starting Balanc
A3=No (for ref
B3=Date (for ref
C3=Time (for ref
D3=Bet (team v team info
E3=Stak
F3/G3/H3=ODDS..e.g F3=3,G3=/,H3=
I3=Winnings (how much I could win
J3=Balance (after bet
K3=Results (Won or Lost

The formula would be something like this
if K3=WON then J2+I3 total would be put in J
if K3=LOST then J2-E3 total would be put in J

Hope this explains it better

 

[John Wilson]

Andrew,

Okay...I'm assuming that the "WON/LOST" in K3 is manually entered???

In J3, enter the following:
=IF(K3="WON",J2+I3,J2-E3)
The above is the simplest way assuming that if K3 isn't "WON" then it
must be "LOST".
A little better would be:
=IF(UPPER(K3)="WON",J2+I3,J2-E3)
allowing you to type in "WoN" any way that you want.

Another option would be:
=IF(UPPER(K3)="WON",J2+I3,IF(UPPER(K3)="LOST",J2-E3,"There Off!!!"))
The above looks for either "WON", or "LOST" with a third option
if K3 is neither.

John