"H" wrote:
what about this when one of the columns has #div/0
=+((X807/T807)*12)/V807

Use JLatham's generic solution (well, almost), namely:

=if(iserror(12*X807/T807/V807), 0, 12*X807/T807/V807)

or

=if(iserror(12*X807/T807/V807), "", 12*X807/T807/V807)

See the help page for Is Functions for the difference between ISERR and
ISERROR. It's a judgment call.

Caveat emptor: If you start returning "" in some cells, it would be prudent
to allow for references to such cells in your formulas. So:

=if(iserror(12*n(X807)/n(T807)/n(V807)), "", 12*n(X807)/n(T807)/n(V807))


----- original message -----

"H" wrote in message
...
what about this when one of the columns has #div/0
=+((X807/T807)*12)/V807

[.....]
"JLatham" wrote:

Here's one that's even more generic, but a little more dangerous -
it
disregards virtually all errors, including divide by zero:
=IF(ISERR(B5/A5),"",B5/A5)
note that you can put something in there to show when it did have a
problem
(most likely a divide by zero:
=IF(ISERR(B5/A5),"---",B5/A5)


"H" wrote:

Hi - is there a way to avoid getting this result #DIV/0? Can I
divide
and get
a line or something instead when there is nothing to divide by?

=B5/A5?

Thank you