Hi, Arvi:

If I understand correctly, all numbers in the list are to be divided by N. She
needs to determine the value of N. I don't think your formula will do that,
will it? N is a variable in your equation.

On Tue, 8 Feb 2005 23:23:20 +0200, "Arvi Laanemets"
wrote:

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?