Thread
:
#Div/0
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Niek Otten
external usenet poster
Posts: 3,440
#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
Reply With Quote
Niek Otten
View Public Profile
Find all posts by Niek Otten