Thread: devide by 0 error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 698
Default devide by 0 error
Typically by using something like this:

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

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Dreamstar_1961" wrote:

is there a way to stop the devide by 0 or empty cell error from showing if
the cell you are using is empty?
Reply With QuoteReply With Quote