View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nabanco nabanco is offline
external usenet poster
 
Posts: 59
Default If Then Or Statement

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.