A little help with a conditional formula, please.

A

Altstatten

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
 
R

Ron Coderre

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

Does that help?

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

XL2002, WinXP-Pro
 
B

Biff

Hi!

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

=IF(OR(A1>10,B1>10),"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(A1>10,B1>10),"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
 
A

Altstatten

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
 
Top