+ Reply to Thread
Results 1 to 9 of 9

Need help - IF Formula

  1. #1
    Registered User
    Join Date
    06-05-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    3

    Need help - IF Formula

    I am doing a spreadsheet to keep track of gambling wins/losses in different sports. I need help with a formula, what i want is this :

    If the outcome box says "WIN" the profit/loss cell will then times K3 and J3 together and then minus J3, If the outcome box says "LOSS" I want the profit loss column to show -J3 spreadsheet.jpg

    Thanks if anyone can help
    Last edited by benallen; 06-05-2013 at 12:41 PM.

  2. #2
    Registered User
    Join Date
    10-28-2012
    Location
    Poland
    MS-Off Ver
    Excel 2007/2010
    Posts
    94

    Re: Help needed

    try this
    =if(L3="WIN";(K3+J3)-J3;if(L3="LOSS";-J3;"""))
    Last edited by young_86; 06-05-2013 at 12:04 PM. Reason: mistake
    Like to say thanks ?Please use the star icon.

  3. #3
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Help needed

    benallen, welcome to the forum. Could you please upload your spreadsheet? We can't do much with a photo of it
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  4. #4
    Forum Contributor
    Join Date
    05-29-2013
    Location
    MD
    MS-Off Ver
    Excel 365
    Posts
    148

    Re: Help needed

    This will work for cell M3.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    for cell E3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-05-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Help needed

    Thanks alot Duncan! problem solved what a great forum this is

  6. #6
    Registered User
    Join Date
    06-05-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Help needed

    The formula for E3 only seems to patrially work, If the stake is 1 it says profit is 0, it seems to be minusing 2.05 regardless of the stake

  7. #7
    Forum Contributor
    Join Date
    05-29-2013
    Location
    MD
    MS-Off Ver
    Excel 365
    Posts
    148

    Re: Help needed

    Sorry, instead of B3*C3-C3,-C3, it should be B3*C3-B3,-B3

    My mistake!

    Don't forget to click the star, and rename the post according to the forum rules.

    Regards

  8. #8
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Help needed

    benallen,

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  9. #9
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Need help - IF Formula

    Your title still does not comply with forum rules. I have changed it for you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1