Excel Help

[Jackie Moon]

Alright first off if I didn't put this in the right spot I'm sorry.
Anywho, I need help with an IF statement in Excel. I have gotten close to getting it but cant. I need the statement to say "IF G3="Win" then the cell = C3+E3, If G3="Loss" then the cell = F3 unless H2>E3"
If it doesnt make sense let me know and I'll try to re-phase it
Points will be given to the first person to get it. Thanks a ton

[Insoluble]

=IF(G3="WIN",C3+E3,IF(g3="loss",if(H2> E3,H2,F3),""))

Made my edit based on your changes

[Emily_Haines]

If H2>E3 then what do you want it to say in cell G3?

[Emily_Haines]

xxxxxxxxxxxxxxx

[Emily_Haines]

delete

[Jackie Moon]

If H2>E3 then what do you want it to say in cell G3?

Sorry. I would want it to have H2
Thanks

[Emily_Haines]

dlete

[thom321]

It isn't clear to me if you want H2>E3 to apply to both win and loss or only to the loss.

If applied to both win and loss:
=IF(H2>E3,H2,IF(G3="Win",C3+E3,IF(G3="Lo ss",F3,"")))

If applied to only loss:
=IF(G3="Win",C3+E3,IF(G3="Loss",IF(H2>E3 ,H2,F3),""))


If there is another possible text in cell G3 (other than "Win" or "Loss"), then you would change the last "" to whatever you want the formula to return if the text in G3 is neither "Win" nor "Loss".

[Emily_Haines]

TRY THIS

IF(G3="win",C3+E3,IF(AND(G3="loss",H2<E3),F3,IF(AND(G3="loss",H2>E3),H2)))

[Jackie Moon]

Hm nothing has worked thus far and I think the problem is my explaining of what I think I need.


Basically I want to type win or loss in the G column and be able to have it add up my bankroll in H2. Thank everybody so much. I know I did a terrible, terrible job explaining it to start.

[LT Profits]

Try =IF(G3="WIN",C2+E2,IF(H2 < E3,H2,F3))

[LT Profits]

I don't know why it's truncating, I added a space before and after the < to make it display