#DIV/0 error
Thanks, I seen what I was doing wrong. I placed a space and another
character on the string. I appreciate the help.
"Peo Sjoblom" wrote:
=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.
|