View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] dktani89@gmail.com is offline
external usenet poster
 
Posts: 2
Default How do I get rid of #DIV/0! part 2

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.