If your calculations in a particular column are dependent on values in some other column which has blank entries in some cells then to avoid any value error you can use a simple “IF” command say column B2 is blank and column D2 is dependent on values in B2 then the equation would be:
=IF(B2=”",”",Formula) Where “” represents blank cell.
Popularity: 5%