Thread: problem of an empty cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
  
Posts: 964
Default problem of an empty cell
Use

=IF(B14=0,0,(C14-B14)/B14)

--


Regards,


Peo Sjoblom

"octet" wrote in message
...
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