SOLVED

IF Data Exists run formula, else return empty

Copper Contributor

Good morning all,

 

Probably a basic question here but any help is appreciated.

 

I have a column of data running a furmula where some rows return a number and others are blank. I need a second column that then analyzes the first and says "If number is positive, return text, if negative return different text, if blank leave blank." My problem is that I can't get the blank part to work. It seems to calculate the blanks as positive numbers. How do I work around this?

First column formula: =IF(N18 = " PUT ", G18-Q18, "")
Second: =IF(T19>0,"WIN","LOSS")

2 Replies
best response confirmed by TurfyRocket (Copper Contributor)
Solution
Use this:
=IF(T19="","",IF(T19>0,"WIN","LOSS"))
Works perfectly. Thank you!
1 best response

Accepted Solutions
best response confirmed by TurfyRocket (Copper Contributor)
Solution
Use this:
=IF(T19="","",IF(T19>0,"WIN","LOSS"))

View solution in original post