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..
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
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.
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
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.
So many options! No wonder people think excel formulas and VBA are so confusing.
Who dat?Originally Posted by gmr4evr1
I dunno
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.
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks