Forum Discussion

TurfyRocket's avatar
TurfyRocket
Copper Contributor
Dec 19, 2023
Solved

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")

Resources