software

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
quot;andquot; and quot;orquot;, acting on one or more cells and different columns.

Thank you.

have you looked in help for both?

--
Don Guillett
SalesAid Software

quot;joanawwquot; gt; wrote in message
...
gt; The courses I took didn't cover multiple conditional statements. Can
gt; someone
gt; help me as to the proper syntax to write these? I need to do conditions
gt; of
gt; quot;andquot; and quot;orquot;, acting on one or more cells and different columns.
gt;
gt; Thank you.
two samples..
=If(AND(b1=3,c1gt;5),quot;Both Coditions existquot;,quot;Neither Condition existsquot;)
=If(OR(b1=3,c1gt;5),quot;Both Coditions existquot;,quot;Neither Condition existsquot;)
quot;joanawwquot; wrote:

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


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

HTH
JG

quot;joanawwquot; wrote:

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


Yes. It only covers sincle conditions syntax.
quot;joanawwquot; wrote:

gt; The courses I took didn't cover multiple conditional statements. Can someone
gt; help me as to the proper syntax to write these? I need to do conditions of
gt; quot;andquot; and quot;orquot;, acting on one or more cells and different columns.
gt;
gt; 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.)

quot;Don Guillettquot; wrote:

gt; have you looked in help for both?
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;joanawwquot; gt; wrote in message
gt; ...
gt; gt; The courses I took didn't cover multiple conditional statements. Can
gt; gt; someone
gt; gt; help me as to the proper syntax to write these? I need to do conditions
gt; gt; of
gt; gt; quot;andquot; and quot;orquot;, acting on one or more cells and different columns.
gt; gt;
gt; gt; Thank you.
gt;
gt;
gt;

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.

quot;Jim Mayquot; wrote:

gt; two samples..
gt; =If(AND(b1=3,c1gt;5),quot;Both Coditions existquot;,quot;Neither Condition existsquot;)
gt; =If(OR(b1=3,c1gt;5),quot;Both Coditions existquot;,quot;Neither Condition existsquot;)
gt;
gt;
gt;
gt; quot;joanawwquot; wrote:
gt;
gt; gt; The courses I took didn't cover multiple conditional statements. Can someone
gt; gt; help me as to the proper syntax to write these? I need to do conditions of
gt; gt; quot;andquot; and quot;orquot;, acting on one or more cells and different columns.
gt; gt;
gt; gt; 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.
quot;pinmasterquot; wrote:

gt;
gt; =IF(AND(conditions seperated by comas),if true,if false)
gt; =IF(OR(conditions seperated by comas),if true,if false)
gt;
gt; HTH
gt; JG
gt;
gt; quot;joanawwquot; wrote:
gt;
gt; gt; The courses I took didn't cover multiple conditional statements. Can someone
gt; gt; help me as to the proper syntax to write these? I need to do conditions of
gt; gt; quot;andquot; and quot;orquot;, acting on one or more cells and different columns.
gt; gt;
gt; gt; Thank you.

I think this last example should be:

=If(OR(b1=3,c1gt;5),quot;One or both Conditions existquot;,quot;Neither Condition
existsquot;)

Pete

quot;Petequot; wrote:

gt; I think this last example should be:
gt;
gt; =If(OR(b1=3,c1gt;5),quot;One or both Conditions existquot;,quot;Neither Condition
gt; existsquot;)
gt;
gt; Pete
gt;
gt; 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).