If Then Or Statement

  • Thread starter Thread starter nabanco
  • Start date Start date
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
 
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"))))
 
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"))))
Click to expand...
 

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

If Then Or Statement 4
formula to add year to date figures 3
how do i if statement for 3 variables 7
IF(ISBLANK for multiple cells A1:N1 6
How to determine the closest degree? 2
If Statement with Multiple Conditions 3
If/Then Statement 20
IF (AND) help.. 3

Back
Top