Excel formula divide list of #s by N to get a number above 40

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?

Hi

=MAX(40,A1/N)

Arvi Laanemets


"JudyK" <JudyK@discussions.microsoft.com> wrote in message
news:3FB1C4C9-745E-4CAD-A20D-0AC346CE9365@microsoft.com...
> 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?

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" <arvilaanemets@hot.ee>
wrote:

>Hi
>
>=MAX(40,A1/N)
>
>Arvi Laanemets
>
>
>"JudyK" <JudyK@discussions.microsoft.com> wrote in message
>news:3FB1C4C9-745E-4CAD-A20D-0AC346CE9365@microsoft.com...
>> 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?
>

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<at>tarkon.ee
Arvi Laanemets


"Myrna Larson" <anonymous@discussions.microsoft.com> wrote in message
news:04hi011kuhvbjpnv74j2vdmhtjef3jpcp9@4ax.com...
> 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" <arvilaanemets@hot.ee>
> wrote:
>
> >Hi
> >
> >=MAX(40,A1/N)
> >
> >Arvi Laanemets
> >
> >
> >"JudyK" <JudyK@discussions.microsoft.com> wrote in message
> >news:3FB1C4C9-745E-4CAD-A20D-0AC346CE9365@microsoft.com...
> >> 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?
> >
>

"Myrna Larson" wrote:
> 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

Arvi Laanemets wrote:
> OP can replace N with any value, or formula, or cell
> reference!

I would agree that Judy's question was very difficult
to understand. But I think Myrna got it right.

Judy wrote: "Is there a formula that will find such a
number?"

What number? Judy wrote: "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."

Translation: Judy wants to find an N such that when
each number in a list is divided by N, the result of
the division will be no less than 40.

Myrna's formula will do just that. It is very elegant
and very obvious at the same time.

Arvi's formula does force the result to be no less than
40. But that does not seem to be what Judy asked for.

Of course, Judy might have simply misstated the problem
she is trying to solve.

Hi


<joeu2004@hotmail.com> wrote in message
news:1107936441.220392.138020@z14g2000cwz.googlegroups.com...
>
> What number? Judy wrote: "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."
>
> Translation: Judy wants to find an N such that when
> each number in a list is divided by N, the result of
> the division will be no less than 40.

My translation: Judy wants to create a new list of numbers, where every
value is N times less than previous one, but not less than 40, i.e. when
N=10 and old value was 800, then the new one will be 80, when old value was
400, the new value is 40, but when old value is p.e. 100, then the new value
will be 40 again.
Of-course OP has to copy mu formula to range (down the column).

--
When sending mail, use address arvil<at>tarkon.ee
Arvi Laanemets

Yes, but the question is HOW TO CALCULATE N. What is the "value, or formula or
cell reference" supposed to be?


On Wed, 9 Feb 2005 08:02:53 +0200, "Arvi Laanemets" <garbage@hot.ee> wrote:

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

Hi

For OP, as follows from message, N is some constant, the value of which she
didn't share with us


Arvi Laanemets


"Myrna Larson" <anonymous@discussions.microsoft.com> wrote in message
news:nakk01hfcvvr3mkdqtt96aohg1u1u7dn1c@4ax.com...
> Yes, but the question is HOW TO CALCULATE N. What is the "value, or
formula or
> cell reference" supposed to be?
>
>
> On Wed, 9 Feb 2005 08:02:53 +0200, "Arvi Laanemets" <garbage@hot.ee>
wrote:
>
> >Hi
> >
> >OP can replace N with any value, or formula, or cell reference! Formulas
can
> >depend on data type, but never on their orign . :-)
>

I am assuming yor list is in A1:A100, and all of the numbers are greater than
0. If we take smallest value in that range and divide it by N, choosing N so
that the result is = 40, then by definition all larger numbers, when divided
by N, will give a result > 40.

In other words, you want to start with this equation

MIN(A1:A100)/N = 40

and solve it for the value of N:

N = MIN(A1:A100)/40

So you want to divide by MIN(A1:A100)/40, i.e.

=A1/(MIN(A1:A20)/40)

PS: This problem has no solution if the list contains both positive and
negative numbers: a negative number would have to be divided by a negative
number to get a result >= +40, whereas positive numbers have to be divided by
a positive number.

On Tue, 8 Feb 2005 13:05:02 -0800, "JudyK" <JudyK@discussions.microsoft.com>
wrote:

>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?