View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Dividing zero by zero

By far the simplest way is to check if the cell contains zero

=IF(B1=0,"",A1/B1)

Mike

"Sanjeev Raghavan" wrote:

In my work sheet 2 column with numbers and in some columns both numbers are
zeros. Is there any forlume I can use in order to get zero as result not
#DIV/0!
Please advice.
Sanjeev