Formula Will Not Divide If Denominator Is Zero or Blank PSS ID Number: Q33548 Article last modified on 01-18-1989 PSS database name: D_MPlan
2.x 3.x 4.00
MS-DOS
Summary:
The following formula will not compute the value of R1C1 divided by R2C1 if the number in R2C1 is “0” or the cell is blank:
IF(OR(R2C1=0,ISBLANK(R2C1)),"",R1C1/R2C1)
This formula is useful if you want to prevent the “#DIV/0!” or “#VALUE!” error message from appearing when division by “0” or by a blank cell is performed.
Copyright Microsoft Corporation 1989.