Hey thanks -- is there a way to do something like this for - I'm getting the
#Div/0 on a few cuz T is 0
=+(X2/T2)*12

"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