Dona
12-13-2005, 10:16 AM
I want to divide d8/b8; however in some cases d8 might be 0 or b8 might be 0. If either d8 and b8 = 0, I want a dash.
Found solution:
=IF(ISERROR(d8/b8),"-",d8/b8)
Found solution:
=IF(ISERROR(d8/b8),"-",d8/b8)
|
View Full Version : dividing Dona 12-13-2005, 10:16 AM I want to divide d8/b8; however in some cases d8 might be 0 or b8 might be 0. If either d8 and b8 = 0, I want a dash. Found solution: =IF(ISERROR(d8/b8),"-",d8/b8) Rickster57 12-13-2005, 11:08 AM =if(b1=0," - ",if(a1=0,"-",a1/b1)) |