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