how do i exclude division by zero....

[sokevin]

Hi.

I want to divide ColumnA by ColumnB.

Howerver columnB includes zeros and texts (letters)

i can exclude zeros by

=if(ColB<>0, A/B, 0)

how do i also exclude division the text.

thanks

 

[AlfD]

Hi!

You could try =IF(NOT(ISNUMBER(B1)),"",IF(B1<>0,A1/B1,""))

Al

 

[Jason Morin]

One way:

=IF(COUNT(A1:B1)<>2,"",A1/B1)

HTH
Jason
Atlanta, GA

 

[Bob Phillips]

=IF(AND(B1<>0,ISNUMBER(B1)),A1/B1,"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Jason Morin]

Oops...use this instead. I need to go home.

=IF(OR(COUNT(A1:B1)<>2,B1=0),"",A1/B1)

HTH
Jason
Atlanta, GA