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

Hi
=if(a5="","",B5/A5)

"H" wrote:

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