Formulas

I am running Excell 2000 Version 9.9.3821 SR-1 on my
Millenium system. I want to have the number in a given
cell recorded automatically in another cell, if the
original number is less than a given amount, but more than
some given amount. I can make a formula for either more
than or less than. For example. . . =If(F520000,F5,) or
=If(F5-20000,F5,). But, I can't set the formula to do
both at the same time. Can you tell what the formula would
be?

one way:

=IF(AND(F5-200000, F520000), F5, "")

Note that you need AND() not OR() since F5 will always be either
-20000 or 20000 or both.

Also, in this case, since the values are symmetrical about zero,
this is a bit more efficient:

=IF(ABS(F5)20000, F5, "")

In article ,
"Richard Shaw" wrote:

I am running Excell 2000 Version 9.9.3821 SR-1 on my
Millenium system. I want to have the number in a given
cell recorded automatically in another cell, if the
original number is less than a given amount, but more than
some given amount. I can make a formula for either more
than or less than. For example. . . =If(F520000,F5,) or
=If(F5-20000,F5,). But, I can't set the formula to do
both at the same time. Can you tell what the formula would
be?

--
Email address ROT-13'd for spam reduction
see www.mcgimpsey.com/excel/groupspam.html to decode

Try:

=If(ABS(F5)20000,F5,)

--
David Hager
Excel FMVP

"Richard Shaw" wrote in message
...
I am running Excell 2000 Version 9.9.3821 SR-1 on my
Millenium system. I want to have the number in a given
cell recorded automatically in another cell, if the
original number is less than a given amount, but more than
some given amount. I can make a formula for either more
than or less than. For example. . . =If(F520000,F5,) or
=If(F5-20000,F5,). But, I can't set the formula to do
both at the same time. Can you tell what the formula would
be?