How do I get rid of #DIV/0!

[dktani89]

Hi,

How do I get rid of #DIV/0! in my cell when I used the following
formula?

=IF(Q3="","",1-(Q3/F3))

I have tried everything and it still shows up in my cells that use
this formula.

thanks for anyhelp that you can give me.

 

[Ian]

It sounds like F3 = 0, is blank or is not numeric. In each case, Excel sees
its numeric value as 0, therefore a divide by zero error.

Ian

 

[Sandy Mann]

What is in F3? An empty cell? A zero?

If empty cell then try:

=IF(OR(Q3="",F3=""),"",1-Q3/F3)

If F3 contains 0 then use:

=IF(OR(Q3="",F3=0),"",1-Q3/F3)

Note that you don't need the inner parentheses because XL's precedence of
operation is multiplication/division then addition/subtraction. If the
parentheses are for clarity then leave them because they are doing no harm.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Dave Peterson]

Maybe you wanted:

=IF(or(Q3="",f3=0),"",1-(Q3/F3))

 

[Teethless mama]

=IF(AND(ISNUMBER(F3),F3>0,Q3<>""),1-(Q3/F3),"")