software

I understand the syntax for an IF formula. (IF(True, Then This, Otherwise
This)

Question is, can I make the first of the three variables an AND or an OR
statement? Have tried a few variations and can't get anything to work.

I'm after...IF(this OR this, then this, otherwiese, this)

Any help??

Thanks
Phillip

=if(or(a1=quot;Altstattenquot;,b1=quot;Altstattenquot;),quot;Yesquot;,quot;Noquot; )

quot;Altstattenquot; wrote:

gt; I understand the syntax for an IF formula. (IF(True, Then This, Otherwise
gt; This)
gt;
gt; Question is, can I make the first of the three variables an AND or an OR
gt; statement? Have tried a few variations and can't get anything to work.
gt;
gt; I'm after...IF(this OR this, then this, otherwiese, this)
gt;
gt; Any help??
gt;
gt; Thanks
gt; Phillip

Try this:
=IF(OR(first_test,second_test),then_this,otherwise _this)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Altstattenquot; wrote:

gt; I understand the syntax for an IF formula. (IF(True, Then This, Otherwise
gt; This)
gt;
gt; Question is, can I make the first of the three variables an AND or an OR
gt; statement? Have tried a few variations and can't get anything to work.
gt;
gt; I'm after...IF(this OR this, then this, otherwiese, this)
gt;
gt; Any help??
gt;
gt; Thanks
gt; Phillip

Hi!

A simple example based on A1 *or* B1 being greater than 10:

=IF(OR(A1gt;10,B1gt;10),quot;Yesquot;,quot;Noquot;)

If *either* A1 or B1 is greater than 10 the formula returns Yes. If neither
is greater than 10 the formula returns No.

A simple example based on A1 *and* B1 being greater than 10:

=IF(AND(A1gt;10,B1gt;10),quot;Yesquot;,quot;Noquot;)

If *both* A1 and B1 are greater than 10 the formula returns Yes, otherwise,
returns No.

For more conditions you can get into:

=IF(OR(AND.....
=IF(AND(OR.....

Biff

quot;Altstattenquot; gt; wrote in message
...
gt;I understand the syntax for an IF formula. (IF(True, Then This, Otherwise
gt; This)
gt;
gt; Question is, can I make the first of the three variables an AND or an OR
gt; statement? Have tried a few variations and can't get anything to work.
gt;
gt; I'm after...IF(this OR this, then this, otherwiese, this)
gt;
gt; Any help??
gt;
gt; Thanks
gt; Phillip
All 3 of ya really oughta be watching a football game or something today, but
I'm glad you're not! Thank you very much!

Phillip

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; A simple example based on A1 *or* B1 being greater than 10:
gt;
gt; =IF(OR(A1gt;10,B1gt;10),quot;Yesquot;,quot;Noquot;)
gt;
gt; If *either* A1 or B1 is greater than 10 the formula returns Yes. If neither
gt; is greater than 10 the formula returns No.
gt;
gt; A simple example based on A1 *and* B1 being greater than 10:
gt;
gt; =IF(AND(A1gt;10,B1gt;10),quot;Yesquot;,quot;Noquot;)
gt;
gt; If *both* A1 and B1 are greater than 10 the formula returns Yes, otherwise,
gt; returns No.
gt;
gt; For more conditions you can get into:
gt;
gt; =IF(OR(AND.....
gt; =IF(AND(OR.....
gt;
gt; Biff
gt;
gt; quot;Altstattenquot; gt; wrote in message
gt; ...
gt; gt;I understand the syntax for an IF formula. (IF(True, Then This, Otherwise
gt; gt; This)
gt; gt;
gt; gt; Question is, can I make the first of the three variables an AND or an OR
gt; gt; statement? Have tried a few variations and can't get anything to work.
gt; gt;
gt; gt; I'm after...IF(this OR this, then this, otherwiese, this)
gt; gt;
gt; gt; Any help??
gt; gt;
gt; gt; Thanks
gt; gt; Phillip
gt;
gt;
gt;