Re: Test if a number falls between 2 values
- From: Gord Dibben <gorddibbATshawDOTca>
- Date: Sat, 21 Jul 2007 14:23:08 -0700
Ron
Don't know why I added the both IF and AND functions.
There was no logic involved, just a typo.
Should have been simply =AND(A1>153,A1<381)
But I see =IF(A1>153,A1<381) also works.
The closer got lost in the copying to the post.
Gord
On Sat, 21 Jul 2007 16:09:48 -0400, Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx>
wrote:
On Sat, 21 Jul 2007 10:47:25 -0700, Gord Dibben <gorddibbATshawDOTca> wrote:
=IF(AND(A1>153),(A1<381)
Interesting formula (although needs another close parentheses).
After I understood the logic, I could simplify it to:
=IF(A1>153,A1<381)
Which is one keystroke shorter than mine:
=AND(A1>153,A1<381)
--ron
.
- References:
- Test if a number falls between 2 values
- From: dalymjl
- Re: Test if a number falls between 2 values
- From: Gord Dibben
- Re: Test if a number falls between 2 values
- From: Ron Rosenfeld
- Test if a number falls between 2 values
- Prev by Date: Re: under standing if statments
- Next by Date: Re: Test if a number falls between 2 values
- Previous by thread: Re: Test if a number falls between 2 values
- Next by thread: Re: Test if a number falls between 2 values
- Index(es):
Relevant Pages
|
