Formulas

  • Thread starter Thread starter Richard Shaw
  • Start date Start date
R

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?
 
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.
Click to expand...

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

=IF(ABS(F5)<20000, F5, "")
 
Back
Top