This formula checks to see if the denominator equals zero (or is blank); if so, it displays a blank cell. For example, if you want to divide cell A1 by cell A2 and put the result in cell A3, the formula in cell A3 would be:
To display other information in the cell if the divisor is blank or zero, type the necessary information in the formula where the "" (quotation marks) appear. If you want to display text, type it between these quotation marks. If you want to display anything else (values), type it instead of the quotation marks.
NOTE: If the denominator is a nonzero value, the division is calculated.
Article ID: 291050 - Last Review: Apr 29, 2008 - Revision: 1