Thread: problem of an empty cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
octet octet is offline
external usenet poster
  
Posts: 8
Default problem of an empty cell
i have an empty cell B14 that says #DIV/0!
does anyone know why this formula i recieve an error try to use this fuction?
=IF(AND(B14<"",B14<0),C14-B14)/B14,"")

Thanks
Octet

Reply With QuoteReply With Quote