#div/0¡ error

[MohdTareq007]

Hi I need help on below so let's say value in cell a1 is 350 b1 is 0 the below formula in c3

=(a1-b1) /b1

I keep receiving #div/0¡ error,

Question is how to remove div error

 

[etaf]

anything divided by 0 is an error

what do you want to be returned ?

=IFERROR((a1-b1) /b1,"")

this returns a blank cell
but you could have a zero

=IFERROR((a1-b1) /b1,0)

 

[Fluff]

Another option is

=if(b1=0,"",(a1-b1) /b1)

 

[MohdTareq007]

anything divided by 0 is an error

what do you want to be returned ?

=IFERROR((a1-b1) /b1,"")

this returns a blank cell
but you could have a zero

=IFERROR((a1-b1) /b1,0)

Tried and worked

 

[etaf]

you are welcome