Forum Discussion
TurfyRocket
Dec 19, 2023Copper 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")
- Use this:
=IF(T19="","",IF(T19>0,"WIN","LOSS"))
2 Replies
Sort By
- JKPieterseSilver ContributorUse this:
=IF(T19="","",IF(T19>0,"WIN","LOSS"))- TurfyRocketCopper ContributorWorks perfectly. Thank you!