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!

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.