You can set Value for new rows that will automatically set a certain value when a new colum is selected. This way you will avoid setting empty value by mistake. You will still be able to remove any value from the cell. You can then also create a button that will filter all rows with empty value, and modify them to have some other value.
Besides that, you can modify your formula to behave differently if the value is blank.