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
|