'And' / 'Or' statements

  • Thread starter Thread starter Apfreight
  • Start date Start date
A

Apfreight

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?
 
Formulas ?
=IF(AND(A1<0,A1>0),"Miracle !!!","Business as usual")
=IF(OR(A1<0,A1>0),"not zero","sheesh")

replace my " " embraced lyrics whith your desired values.
 
Back
Top