It depends what You are doing.
You may use IF function, for instance. Assuming that You want to divide
value in cell A2 by value in B2 You may write a following formula:
=IF(B2=0,0,A2/B2)
It will check if value in B2 equals 0 and if so return 0, if the opposite
return result of A2/B2.
"courtesio99" wrote in message
...
Is there any way to set a cell to 0 if any error(eg DIV/0 or VALUE)
occurs?
---
Message posted from http://www.ExcelForum.com/