Hi

OP can replace N with any value, or formula, or cell reference! Formulas can
depend on data type, but never on their orign . :-)

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Myrna Larson" wrote in message
...
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?