{"id":2851,"date":"2018-08-08T11:57:39","date_gmt":"2018-08-08T11:57:39","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=2851"},"modified":"2024-04-17T07:46:48","modified_gmt":"2024-04-17T07:46:48","slug":"leave-a-cell-blank-if-the-condition-is-false","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/leave-a-cell-blank-if-the-condition-is-false\/","title":{"rendered":"Leave a Cell Blank if the Condition Is False"},"content":{"rendered":"\n
The following formula will check cell A1, and if the condition is False<\/strong> (value != 2) it returns blank<\/strong>, otherwise (value = 2) it returns A1.<\/p>\n\n\n\n Now, when you highlight the formula, you can see that the value of the cell is blank<\/a>, but there is a formula inside.<\/p>\n\n\n\nA1: 2\nB1: =IF((A1=2),A1,\"\")<\/code><\/pre>\n\n\n\n