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.