| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
'And' / 'Or' statements
Doing something wrong. Trying to use 'and' and 'or' statements to generate a
value, but can only get them to generate a true/false result. Need to use 'and' and 'or' statements within 'if' statements. Anybody know how to get these to generate values? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
'And' / 'Or' statements
Formulas ?
=IF(AND(A1<0,A10),"Miracle !!!","Business as usual") =IF(OR(A1<0,A10),"not zero","sheesh") replace my " " embraced lyrics whith your desired values. -- HTH. Best wishes Harald Excel MVP Followup to newsgroup only please. "Apfreight" wrote in message ... Doing something wrong. Trying to use 'and' and 'or' statements to generate a value, but can only get them to generate a true/false result. Need to use 'and' and 'or' statements within 'if' statements. Anybody know how to get these to generate values? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'COUNTIF' and 'AND' | Excel Discussion (Misc queries) | |||
| 'if' and 'and' | Excel Worksheet Functions | |||
| I think this is either 'IF' or 'And' | Excel Discussion (Misc queries) | |||
| How do I use 'And' or "Or" in an If statment | Excel Worksheet Functions | |||
| not a logical 'and' in excel? | Excel Worksheet Functions | |||
Linear Mode
