Thread: Error Terms
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Error Terms
One way:

Instead of

=A1/B1

use

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

In article ,
Michael Gudyka wrote:

How can I get an error term, such as #DIV/0!, to display as just a zero?
Thanks
Reply With QuoteReply With Quote