formula for insert if one column is blank in excel if formula
Answers
Answered by
0
If cell is blank

Generic formula
=IF(A1="","blank","not blank")
Explanation
If you want to test a cell and take some action if the cell is blank (empty), you can use the IF function.
In the example shown column D contains a date indicating when a task was completed. In column E, a formula checks for blank cells in column D. If a cell is blank, the result is a status of "Open". If the cell contains a value (a date in this case, but it could be any value) the formula assigns status of "Closed". The formula in cell E5 is:
=IF(D5="","Open","Closed")
The logical expression ="" can be thought of as meaning "is empty"
The effect of showing "Closed" in light gray is accomplished with a conditional formatting rule.
Display nothing if cell is not blank
If you only want to display a value if a cell is blank, you can replace the "value if false" argument in the IF function with an empty string (""). The formula would then be:

Generic formula
=IF(A1="","blank","not blank")
Explanation
If you want to test a cell and take some action if the cell is blank (empty), you can use the IF function.
In the example shown column D contains a date indicating when a task was completed. In column E, a formula checks for blank cells in column D. If a cell is blank, the result is a status of "Open". If the cell contains a value (a date in this case, but it could be any value) the formula assigns status of "Closed". The formula in cell E5 is:
=IF(D5="","Open","Closed")
The logical expression ="" can be thought of as meaning "is empty"
The effect of showing "Closed" in light gray is accomplished with a conditional formatting rule.
Display nothing if cell is not blank
If you only want to display a value if a cell is blank, you can replace the "value if false" argument in the IF function with an empty string (""). The formula would then be:
Similar questions