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

Try this:

=IF(OR(F3="",F3=0),"",G3/F3)

Hope this helps.

Pete

On Nov 27, 6:30 pm, Douglas @ Helpdesk
wrote:
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?