What if A1 is not X and not is blank?
If N1 = "Government" and A1 not is blank, then...?
What if V1 not greater than 7 and W1 not greater than 1?

I probably missed a few.
Please specify *exactly* what the requirements are.

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