Thread: #Div/0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default #Div/0

=IF(A5=0,"",B5/A5)

"H" wrote in message
...
Hi - is there a way to avoid getting this result #DIV/0? Can I divide and
get
a line or something instead when there is nothing to divide by?

=B5/A5?

Thank you