Thank you all for your replies. This is what occured to me late last night
and what I wound up doing:

I realized that what I was looking for here was the Maximum number resulting
from dividing a constant by the Minimum number in a range. So I did

=IF(A1=0,"",Constant/A1)

and copied it for each cell in my original range creating a range of results
in a separate column B that I later hid. This weeded out all the cells
containing zero.

I then used

=Max(B1:B10)

to obtain the result I was actually after.


"Opus" wrote:

I need to find the minimum non-zero number in a range of cells that contains
some zeroes. So that I can divide by the minimum number. Any ideas?

If I just use the MIN function, it returns a value of 0, then when my
formula divides by that I get the divide by zero error.