Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
=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 |
#6
|
|||
|
|||
Alternatively:
=A175 In article , "Bob Phillips" wrote: =IF(A175,True,False) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Greater than when a formula Results in N/A | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
input value in a cell when the previous cell is greater than 0 | New Users to Excel | |||
Linking items GREATER THAN O on another worksheet in the same Work | Excel Discussion (Misc queries) |