# Calculate win or loss

1. ## 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!

Try this..

3. ## Re: Calculate win or loss

=IF(M9>0,"WIN",IF(ISBLANK(M9),"","Loss"))

4. ## Re: Calculate win or loss

Try to use:

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

Is that what you're looking for?
I hope it helps.

5. ## Re: Calculate win or loss

Here's another one...

=IF(COUNT(M9),IF(M9>0,"Win","Loss"),"")

6. ## Re: Calculate win or loss

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

7. ## Re: Calculate win or loss

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

I dunno

9. ## 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. ## 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

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

#### 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