View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default problem of an empty cell

Try this:

=IF(N(B14),(C14-B14)/B14,"")


"octet" wrote:

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