If Then Or Statement

N

nabanco

Hello,

I am having a little trouble with this formula and was hoping for some help.

=IF(A1="X","Complete",IF(A1="",IF(OR(N1="Bond",N1="Other"),"Yes",IF(AND(N1="Government",OR(V1>7,W1>1)),"Yes","???"))))


If N1 equals "government" AND (V1 is >7 and less than 100) OR (W1 is >0 and
less than 100) then return "Yes". If not, return "No.

The first part of the formula works fine for "bond" and "other"

Thank you
 
M

Max

Maybe you're looking for something like this:
=IF(A1="X","Complete",IF(A1="",IF(OR(N1="Bond",N1="Other"),"Yes",IF(AND(N1="Government",OR(AND(V1>7,V1<100),AND(W1>0,W1<100))),"Yes","No"))))
 
N

nabanco

Max, that worked perfectly, thank you sir

Max said:
Maybe you're looking for something like this:
=IF(A1="X","Complete",IF(A1="",IF(OR(N1="Bond",N1="Other"),"Yes",IF(AND(N1="Government",OR(AND(V1>7,V1<100),AND(W1>0,W1<100))),"Yes","No"))))
 

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

Top