What would be a command line to change the results in a cell from #DIV/0 to zero?
M mulehead May 20, 2008 #1 What would be a command line to change the results in a cell from #DIV/0 to zero?
M Max May 20, 2008 #2 One way is to trap for the denominator being blank/containing a zero, eg: =IF(OR(B1="",B1=0),0,A1/B1)
One way is to trap for the denominator being blank/containing a zero, eg: =IF(OR(B1="",B1=0),0,A1/B1)
