Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ernesta Fernandez   on Aug 20 In MS Office Category.

Please Help on IF AND OR logic


  
Question Answered By: Tate Thompson   on Aug 20

Does this formula do what you want?

=IF(OR(AD2="DEAD",AD2="Permission Denied"),"Not
Collected",IF(AND(AE2<=1,AF2<=4000,AN2<75),"Candidate","Not Candidate"))

Share: 

 

This Question has 5 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Please Help on IF AND OR logic Or get search suggestion and latest updates.


Tagged: