Rick, thank you so much, that worked beautifully

"Rick Rothstein (MVP - VB)" wrote:

I'm not sure if this does what you want or not, so you will have to test it to see...

=IF(A1="X","Complete",IF(A1="",IF(OR(N1="Bond",N1= "Other"),"Yes",IF(AND(N1="Government",OR(V17,W11 )),"Yes","???"))))

Note there is a "???" at the end of the formula... you didn't state a return value for this fall through condition, so I used "???"... perhaps you simply want to return a blank for it (just use "" instead of "???" if that is the case).

Rick


"nabanco" wrote in message ...
Hi,

I'm having a little problem figuring this one out. I'm trying to create a
statement in excel 2003 that would accomplish the below:

If A1="X", then return "complete"

If A1 is blank, then we need to return "Yes" if N1 equals "Bond" or "Other".
If N1 equals "Government", then we need to return "Yes" if V1 is greter than
7 OR W1 is greater than 1.

Thanks for any help you can provide, this one is way above me.