Create a formula using if, and, or or.
 

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.

Create a formula using if, and, or or.
 

have you looked in help for both?

--
Don Guillett
SalesAid Software

"joanaww" wrote in message
...
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.

Create a formula using if, and, or or.
 

two samples..
=If(AND(b1=3,c15),"Both Coditions exist","Neither Condition exists")
=If(OR(b1=3,c15),"Both Coditions exist","Neither Condition exists")



"joanaww" wrote:

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.

Create a formula using if, and, or or.
 

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

HTH
JG

"joanaww" wrote:

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.

Create a formula using if, and, or or.
 

Yes. It only covers sincle conditions syntax.
"joanaww" wrote:

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.

Create a formula using if, and, or or.
 

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

"Don Guillett" wrote:

have you looked in help for both?

--
Don Guillett
SalesAid Software

"joanaww" wrote in message
...
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.

Create a formula using if, and, or or.
 

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.

"Jim May" wrote:

two samples..
=If(AND(b1=3,c15),"Both Coditions exist","Neither Condition exists")
=If(OR(b1=3,c15),"Both Coditions exist","Neither Condition exists")



"joanaww" wrote:

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.

Create a formula using if, and, or or.
 

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.
"pinmaster" wrote:


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

HTH
JG

"joanaww" wrote:

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.

Create a formula using if, and, or or.
 

I think this last example should be:

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

Pete

Create a formula using if, and, or or.
 

"Pete" wrote:

I think this last example should be:

=If(OR(b1=3,c15),"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).

Create a formula using if, and, or or.
 

"joanaww" wrote:

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.)

"Pete" wrote:

I think this last example should be:

=If(OR(b1=3,c15),"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).

Create a formula using if, and, or or.
 

try this link
http://www.personal-computer-tutor.com/if2.htm

"joanaww" wrote:


Yes. It only covers sincle conditions syntax.
"joanaww" wrote:

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.

Create a formula using if, and, or or.
 

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

"Dsuperc" wrote:

try this link
http://www.personal-computer-tutor.com/if2.htm

"joanaww" wrote:


Yes. It only covers sincle conditions syntax.
"joanaww" wrote:

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.