A little help with a conditional formula, please.
 

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

A little help with a conditional formula, please.
 

=if(or(a1="Altstatten",b1="Altstatten"),"Yes","No" )

"Altstatten" wrote:

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

A little help with a conditional formula, please.
 

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

Does that help?

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

XL2002, WinXP-Pro


"Altstatten" wrote:

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

A little help with a conditional formula, please.
 

Hi!

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

=IF(OR(A110,B110),"Yes","No")

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(A110,B110),"Yes","No")

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

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

A little help with a conditional formula, please.
 

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

"Biff" wrote:

Hi!

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

=IF(OR(A110,B110),"Yes","No")

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(A110,B110),"Yes","No")

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

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