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.

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.

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.

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

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.

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.

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.

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.

I think this last example should be:

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

Pete

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

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

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.

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.