Formulas

[Richard Shaw]

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(F5<20000,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?

 

[J.E. McGimpsey]

one way:

=IF(AND(F5>-200000, F5<20000), 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, "")

 

[David Hager]

Try:

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