Hello,
I would like some help in evaluating the value of a cell that falls within a
certain range.
For example:
If A2 is less than 1 and greater than 10 "TRUE"
Your help is appreciated.
Ed
Hello,
I would like some help in evaluating the value of a cell that falls within a
certain range.
For example:
If A2 is less than 1 and greater than 10 "TRUE"
Your help is appreciated.
Ed
Good afternoon
A2 can never be less than1 AND greater than 10; I think you mean if A2 is greater than 1 or less than 10. This should work:
=IF(A2>1,IF(A2<10,"TRUE","FALSE"))
This will return TRUE for number 2 through 9 - if you want to include numbers 1 and 10 use >= and <= in the formula.
Hope this solves your problem.
Hi Eduardo
do you mean if A2 is less than 1 OR greater than 10???
if so
format / conditional formatting
formula is
=OR($A2<1,$A2>10)
or if you mean greater than 1 and less than 10
=AND($B1>1,$B1<10)
Cheers
JulieD
"Eduardo" <[email protected]> wrote in message
news:[email protected]...
> Hello,
> I would like some help in evaluating the value of a cell that falls within
> a
> certain range.
> For example:
> If A2 is less than 1 and greater than 10 "TRUE"
>
> Your help is appreciated.
>
> Ed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks