View Single Post
  #5   Report Post  
Bob Phillips
 
Posts: n/a
Default

=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