#value!

When calcualting cells, is there a way I can avoid #VALUE! popping up?

For example if I am dividing and some cells are zero, then I can avoid #DIV/0! by typing =if(A1=0," ",B1/A1)

Is there a similar work around?

MQ

Wrap your formula in IFERROR()...
=IFERROR(your-formula,"")

Aslo, avoide using " " (with a space), rather, use "" (no space). You can use other formulas that can be based on a "null" entry...=if(a1="","",123), but if you have a space, then you need to remember to that you added a space