Greater then/less then

[Guest]

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

 

[Bob Phillips]

=IF(AND(A1>0,A1<=75),True,False)

--

HTH

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

 

[Guest]

THANK YOU!!

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

 

[Guest]

I thought of a new question

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

 

[Bob Phillips]

=IF(A1>75,True,False)

--

HTH

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

 

[JE McGimpsey]

Alternatively:

=A1>75