Greater then/less then
 

I am looking for a foruma that is combined with the "IF" function for an
example

person a has 50 pts

if persona a has 1-75 pt, then the stat,ent is true

=IF(AND(A10,A1<=75),True,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"campsoup1988" wrote in message
...
I am looking for a foruma that is combined with the "IF" function for an
example

person a has 50 pts

if persona a has 1-75 pt, then the stat,ent is true

THANK YOU!!

Seing the formula now, it makes sense, but I couldn't think of it!

"Bob Phillips" wrote:

=IF(AND(A10,A1<=75),True,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"campsoup1988" wrote in message
...
I am looking for a foruma that is combined with the "IF" function for an
example

person a has 50 pts

if persona a has 1-75 pt, then the stat,ent is true

I thought of a new question

Same sanario, but instead of 1-75 to be true, 75+ (anything over 75) being
true

"Bob Phillips" wrote:

=IF(AND(A10,A1<=75),True,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"campsoup1988" wrote in message
...
I am looking for a foruma that is combined with the "IF" function for an
example

person a has 50 pts

if persona a has 1-75 pt, then the stat,ent is true

=IF(A175,True,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"campsoup1988" wrote in message
...
I thought of a new question

Same sanario, but instead of 1-75 to be true, 75+ (anything over 75) being
true

"Bob Phillips" wrote:

=IF(AND(A10,A1<=75),True,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"campsoup1988" wrote in message
...
I am looking for a foruma that is combined with the "IF" function for
an
example

person a has 50 pts

if persona a has 1-75 pt, then the stat,ent is true

Alternatively:

=A175

In article ,
"Bob Phillips" wrote:

=IF(A175,True,False)