# 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!  Register To Reply

2. ## Re: Calculate win or loss

Try this.. ``Please Login or Register  to view this content.``  Register To Reply

3. ## Re: Calculate win or loss

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

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.  Register To Reply

5. ## Re: Calculate win or loss

Here's another one...

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

6. ## Re: Calculate win or loss

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

7. ## Re: Calculate win or loss Originally Posted by gmr4evr1 No wonder people think excel formulas ... are so confusing.
Who dat?   Register To Reply

8. ## Re: Calculate win or loss

I dunno   Register To Reply

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.  Register To Reply

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  Register To Reply