'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?

'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?