View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default #DIV/0! - how to get rid of it

Beginning with Excel 2007...

=IFERROR(G3/F3,"")

- -
HTH
Dana DeLouis


"Douglas @ Helpdesk" wrote in
message ...
I have a user that the formula is H3=G3/F3 - where both g3 and f3 are blank
b/c they are not populated. The user wants them there so when the field
would be populated they would fill H3 correctly. The customer doesnt want
to
see #DIV/0! going down the page. How could i fix this issue without having
0
all the way down and still have the functionality when the fields are
populated?