1. 06-16-12 02:13 PM #1
    Jackie Moon
    Jackie Moon's Avatar Become A Pro!
    Join Date: 04-21-11
    Posts: 207
    Betpoints: 0

    Excel Help

    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
    Last edited by Jackie Moon; 06-16-12 at 02:49 PM. Reason: typo
    Reply With Quote Reply With Quote
  2. 06-16-12 02:44 PM #2
    Insoluble
    Insoluble's Avatar Become A Pro!
    Join Date: 05-29-10
    Posts: 71
    Betpoints: 3463

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

    Made my edit based on your changes
    Last edited by Insoluble; 06-16-12 at 05:24 PM.
    Reply With Quote Reply With Quote
  3. 06-16-12 03:14 PM #3
    Emily_Haines
    Emily_Haines's Avatar Become A Pro!
    Join Date: 04-14-09
    Posts: 15,888
    Betpoints: 15319

    If H2>E3 then what do you want it to say in cell G3?
    Reply With Quote Reply With Quote
  4. 06-16-12 03:46 PM #4
    Emily_Haines
    Emily_Haines's Avatar Become A Pro!
    Join Date: 04-14-09
    Posts: 15,888
    Betpoints: 15319

    xxxxxxxxxxxxxxx
    Reply With Quote Reply With Quote
  5. 06-16-12 03:52 PM #5
    Emily_Haines
    Emily_Haines's Avatar Become A Pro!
    Join Date: 04-14-09
    Posts: 15,888
    Betpoints: 15319

    delete
    Reply With Quote Reply With Quote
  6. 06-16-12 04:03 PM #6
    Jackie Moon
    Jackie Moon's Avatar Become A Pro!
    Join Date: 04-21-11
    Posts: 207
    Betpoints: 0

    Quote Originally Posted by Emily_Haines View Post
    If H2>E3 then what do you want it to say in cell G3?
    Sorry. I would want it to have H2
    Thanks
    Reply With Quote Reply With Quote
  7. 06-16-12 04:07 PM #7
    Emily_Haines
    Emily_Haines's Avatar Become A Pro!
    Join Date: 04-14-09
    Posts: 15,888
    Betpoints: 15319

    dlete
    Last edited by Emily_Haines; 06-16-12 at 04:12 PM.
    Reply With Quote Reply With Quote
  8. 06-16-12 04:19 PM #8
    thom321
    thom321's Avatar Become A Pro!
    Join Date: 06-17-11
    Posts: 112
    Betpoints: 4983

    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="Loss",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".
    Last edited by thom321; 06-16-12 at 04:25 PM. Reason: New info
    Reply With Quote Reply With Quote
  9. 06-16-12 04:20 PM #9
    Emily_Haines
    Emily_Haines's Avatar Become A Pro!
    Join Date: 04-14-09
    Posts: 15,888
    Betpoints: 15319

    TRY THIS


    HTML Code:
    IF(G3="win",C3+E3,IF(AND(G3="loss",H2<E3),F3,IF(AND(G3="loss",H2>E3),H2)))
    Reply With Quote Reply With Quote
  10. 06-16-12 04:33 PM #10
    Jackie Moon
    Jackie Moon's Avatar Become A Pro!
    Join Date: 04-21-11
    Posts: 207
    Betpoints: 0

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

    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.
    Attached Images  
    Reply With Quote Reply With Quote
  11. 06-16-12 04:55 PM #11
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Try =IF(G3="WIN",C2+E2,IF(H2 < E3,H2,F3))
    Last edited by LT Profits; 06-16-12 at 05:00 PM.
    Reply With Quote Reply With Quote
  12. 06-16-12 04:59 PM #12
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    I don't know why it's truncating, I added a space before and after the < to make it display
    Reply With Quote Reply With Quote
Top
« Previous Thread | Handicapper Think Tank | Next Thread »