Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Help with nested if statement - with and & or

  Asked By: Harry    Date: Nov 09    Category: MS Office    Views: 804
  

Having a brain freeze - can't get the syntax quite right. Hoping
someone can help me ...

Col
A B C
1 Process Steve Steve
2 Service John Service
3 Process Jeff Jeff

If result in A1 = "Process" and B1 = "Steve" or "Jeff", bring back the
result from col B otherwise bring back the result from col A (put the
formula's result in col C).

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Nathan Evans     Answered On: Nov 09

Are you looking for a VBA-related answer? If so, I'm not sure what
you're asking. If not, either of these formula should work:

=IF(A1="Process",IF(B1="Steve",B1,IF(B1="Jeff",B1,A1)),A1)

=IF(AND(A1="Process",OR(B1="Steve",B1="Jeff")),B1,A1)

 
Didn't find what you were looking for? Find more on Help with nested if statement - with and & or Or get search suggestion and latest updates.




Tagged: