Hi

=MAX(40,A1/N)

Arvi Laanemets


"JudyK" wrote in message
...
I have a list of numbers. I need to divide each of those numbers by the
same
number ("N") that will give me a resulting list in which all of the
numbers
are at least 40 or above. Is there a formula that will find such a
number?