Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. | Excel Worksheet Functions | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
conditional formula | Excel Worksheet Functions | |||
Conditional Formatting formula not acceptable? | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) |