D Dona Registered User. Local time Today, 05:59 Joined Jun 27, 2002 Messages 55 Dec 13, 2005 #1 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) Last edited: Dec 13, 2005
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)
R Rickster57 Registered User. Local time Yesterday, 21:59 Joined Nov 7, 2005 Messages 431 Dec 13, 2005 #2 =if(b1=0," - ",if(a1=0,"-",a1/b1))
