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!