What is this? From this page you can use the Social Web links to save Avoiding blank cells to a social bookmarking site, or the E-mail form to send a link via e-mail.

Social Web

E-mail

E-mail It
November 22, 2007

Avoiding blank cells

Posted in: General

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.

Return to: Avoiding blank cells