SOLVED

# IF Data Exists run formula, else return empty

Copper Contributor

# IF Data Exists run formula, else return empty

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

# Re: IF Data Exists run formula, else return empty

Use this:
=IF(T19="","",IF(T19>0,"WIN","LOSS"))

# Re: IF Data Exists run formula, else return empty

Works perfectly. Thank you!
1 best response

Accepted Solutions
best response confirmed by TurfyRocket (Copper Contributor)
Solution

# Re: IF Data Exists run formula, else return empty

Use this:
=IF(T19="","",IF(T19>0,"WIN","LOSS"))