How do I get rid of #DIV/0!
 

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.

How do I get rid of #DIV/0!
 

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

wrote in message
oups.com...
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.

How do I get rid of #DIV/0!
 

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


Replace @mailinator.com with @tiscali.co.uk


wrote in message
oups.com...
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.

How do I get rid of #DIV/0!
 

Maybe you wanted:

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



wrote:

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.

--

Dave Peterson

How do I get rid of #DIV/0!
 

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


" wrote:

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.