Microsoft KB Archive/33548

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)),&quot;&quot;,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.