+ Reply to Thread
Results 1 to 10 of 10

Calculate win or loss

  1. #1
    Registered User
    Join Date
    06-08-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    23

    Calculate win or loss

    Hello all! I am trying to calculate a win or a loss in cell N using this formula: =IF(M9>0,"WIN","LOSS")
    Cell M is a numerical value of profit or loss so if the number is greater than zero it calculates the win but if lower than zero it calculates the loss. My issue is for blank cells it is calculating a win instead of nothing at all. Your help is appreciated, thanks!

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Calculate win or loss

    Try this..
    Please Login or Register  to view this content.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,449

    Re: Calculate win or loss

    Hi rapid trader,

    Try this instead of your formula

    =IF(M9>0,"WIN",IF(ISBLANK(M9),"","Loss"))
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Valued Forum Contributor
    Join Date
    05-13-2010
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Excel 2003; 2007
    Posts
    441

    Re: Calculate win or loss

    ChaosTrader63, Good evening.

    Try to use:

    =IF(AND(M9>0,M9<>" "),"WIN","LOSS")

    Is that what you're looking for?
    I hope it helps.
    ...If my answer helped you, Please, click on. * Add Reputation (at left)

    Best regards.
    Marcílio Lobão

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Calculate win or loss

    Here's another one...

    =IF(COUNT(M9),IF(M9>0,"Win","Loss"),"")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  6. #6
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Calculate win or loss

    So many options! No wonder people think excel formulas and VBA are so confusing.

  7. #7
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Calculate win or loss

    Quote Originally Posted by gmr4evr1 View Post
    No wonder people think excel formulas ... are so confusing.
    Who dat?

  8. #8
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Calculate win or loss

    I dunno

  9. #9
    Registered User
    Join Date
    06-08-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Calculate win or loss

    Ok well none of the formulas are working as far as not placing a win or loss in the blank cell. It's like win should be greater than zero and loss should be less than zero but in a blank cell with no numerical value there shouldn't be anything.

  10. #10
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Calculate win or loss

    The only one of the ones posted in this thread that didn't work correctly in my workbook was the IF(AND one, all the others worked as you wanted them to. In the attached, place a value (negative or positive) in cell M9 (yellow) and then watch the green cells change as you do. As you will see when you open it, all the green cells are blank when you open the file, with the exception of P6, as that is the one I started didn't work when M9 was blank.
    Chaos Win-Loss.xlsx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to calculate points - Win, Tie and Loss situations
    By SVTF in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-23-2014, 09:39 PM
  2. Calculate profit/loss
    By Boldsen in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-23-2014, 08:34 AM
  3. [SOLVED] calculate the longest loss period
    By kmaloney01 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-02-2014, 08:11 AM
  4. Replies: 7
    Last Post: 08-03-2013, 09:51 AM
  5. [SOLVED] Calculate Opponents Win Loss Record
    By TGCRequiem in forum Excel General
    Replies: 8
    Last Post: 06-25-2012, 05:43 PM
  6. Method needed to calculate sale profit/loss
    By h1981 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-28-2011, 06:49 PM
  7. How to calculate total probability of loss from combination of probabilities
    By prr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2009, 06:48 PM

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