IF function SharePoint - Not Empty Column

How would I specify if a column is not empty or blank in an IF stat开发者_C百科ement - in a calculated column formula?

---

There is a function ISBLANK([Column Name]) that you can also use:

=IF(ISBLANK([My Column]),"EMPTY",[My Column])

---

you can use the LEN([column]) function i.e.. IF(LEN([column]) > 0,'yay','nay')

---

To check if column is null/blank best way is to do something like this:

=IF([column1]<>"","Not blank", "")

the reason this is best because you can add and & or into the formula