{"id":3926,"date":"2019-01-09T13:06:54","date_gmt":"2019-01-09T13:06:54","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3926"},"modified":"2024-03-29T14:12:04","modified_gmt":"2024-03-29T14:12:04","slug":"if-cell-is-not-blank-then-do-if-statement","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/if-cell-is-not-blank-then-do-if-statement\/","title":{"rendered":"Excel – If Cell is Not Blank, then do IF Statement"},"content":{"rendered":"\n
If you want a formula that inserts a text, instead of leaving blank cells, you can use the ISBLANK function<\/a>. This function returns TRUE<\/strong> if a referenced cell is empty or FALSE<\/strong> if it contains any other value.<\/p>\n\n\n\n Here\u2019s how it works.<\/p>\n\n\n\n