Thread: #DIV/0 error
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default #DIV/0 error

=IF('Product'!P21=0,0,'Product'!P20/'Product'!P21)



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Daniell" wrote in message
...
What I am working with is a simple divide statment using two worksheets.

=('Product'!P20/'Product'!P21)

If the answer comes out to zero I get the #DIV/0!, is there a solution to
just putting a zero in that cell?

Thanks in advance.