#div/0!

[Acoustic]

hi all

i have here, hopefully a very simple one that i havent been able to find anywhere.
i have for example, 2 senarios A1=10 and B1=0
and A2=0 and B2=10

i am trying to return errors as a zero value.
what i have got so far is IF(A1=0,0,A1/B1)

this works if A1 is zero, but when B1 has a zero im a bit stuck for what to put as a formula

hope that is enough information cheers

 

[Marcelo Branco]

Hi Acoustic,

Maybe i'm missing something, but if A1 = 0 the formula A1/B1 returns 0, so you wouldnt need the condition IF(A1=0,0

Maybe you need something like
=IF(B1<>0, A1/B1, "some message/value")

HTH

M.

 

[Sektor]

=iferror(if(a1=0,0,a1/b1),0)

 

[Tom Urtis]

=if(b1,a1/b1,0)

 

[Acoustic]

awesome guys cheers, thanks, they both work great. I understand the first one, not fully grasping the secong reply though, although it looks so simple

cheers all the same