Create a formula using if, and, or or.

J

joanaww

The courses I took didn't cover multiple conditional statements. Can someone
help me as to the proper syntax to write these? I need to do conditions of
"and" and "or", acting on one or more cells and different columns.

Thank you.
 
J

Jim May

two samples..
=If(AND(b1=3,c1>5),"Both Coditions exist","Neither Condition exists")
=If(OR(b1=3,c1>5),"Both Coditions exist","Neither Condition exists")
 
P

pinmaster

=IF(AND(conditions seperated by comas),if true,if false)
=IF(OR(conditions seperated by comas),if true,if false)

HTH
JG
 
J

joanaww

No, it only covers single condition syntax. (in error I posted the reply to
my own question, so I hope no one's confused.)
 
J

joanaww

Thanks. Can we go one step farther, and combine the two? Use of brackets,
parentheses, etc. would be helpful in the combined statement. I am asking
the same question to pinmaster.
 
J

joanaww

Same question I added for Jim May's reply: Can we go one step farther, and
combine the two? Use of brackets, parentheses, etc. would be helpful in the
combined statement.

Thanks.
 
P

Pete

I think this last example should be:

=If(OR(b1=3,c1>5),"One or both Conditions exist","Neither Condition
exists")

Pete
 
J

joanaww

Pete said:
I think this last example should be:

=If(OR(b1=3,c1>5),"One or both Conditions exist","Neither Condition
exists")

Pete

I just tried this, but maybe I did something wrong. I'm actually using this statement as a condition for a sumif statement, where a column contains several dates, and either of two of them might qualify as criteria for a given time period. I can do this if I have only one month I'm searching for. Actually, I'm trying to sum up the amounts paid, which can come in any month, by time period (corresponding to meeting dates).
Click to expand...
 
J

joanaww

joanaww said:
I just tried this, but maybe I did something wrong. I'm actually using this statement as a condition for a sumif statement, where a column contains several dates, and either of two of them might qualify as criteria for a given time period. I can do this if I have only one month I'm searching for. Actually, I'm trying to sum up the amounts paid, which can come in any month, by time period (corresponding to meeting dates). (I'm having trouble using this form, as I don't know where I'm supposed to type my reply - there is no blinking cursor.)
Click to expand...
 
J

joanaww

Thanks so much. I think this site will provide me with the information I
need to complete my project.
Joan
 
Top