'And' / 'Or' statements

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

Harald Staff

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
VBA Export to PDF 0
Incone & Expenses Statement 0
Office365 Family + TXT or MX Domain 0
Check if there is a space in a string as test for IF 1
Testing a string againsts a list of strings 2
Word macro that can call cells out of Excel for a find and replace 0
Excel Macro Programing Problem 2

Top