your explanation worked out perfectly, and sorted my problem without further
complications. thanks to you. but before i leave, just out of curiosity may i
ask, is CHENOPOD (the one who bought the similar issue first) has the same
problem as mine, or is he refering to something else?

"JE McGimpsey" wrote:

Multiplication and addition happen before the data is entered, just as
division does. The difference is that multiplication by zero and
addition of zero are defined, whereas division by zero is not, hence the
error.

Note that ISERROR() will mask any other errors you have. It's usually
better to trap only "expected" errors:

C1: =IF(B1=0,"",A1/B1)





In article ,
"azmi" wrote:

appriciate your prompt reply. my issue was, the formula displays (#DIV/0!)
BEFORE entering the data. i.e., the formula is entered first, and the
relevent data is to be entered at a later stage.as far as i know this only
happens when you devide a value by zero or when the formula has to devide
zero by zero. this does not happen when you multiply or add. hence this cell
which gives (#DIV/0!) will continue to be the same to all formulas which
refers this particula cell(s). howerver i managed to find that "ISERROR"
function eliminates this issue.

A1=0
B1=0
C1=A1/B1=#DIV/0!

SOLUTION
C1=IF(ISERROR(A1/B1),'''',A1/B1)