First format the cell as %

then:

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

--
Gary''s Student - gsnu2007a


" wrote:

Hi

I tried the suggestions that were given to me. The only problem is
that they will show a percentage in .00 instead of %. They want me to
get the the answer in %. I just cannot get this to work. It will
work once the cells are filled and it computes. But until then the
cell shows #DIV/0!


Original Message:

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.