IF & AND functions

Good day

 

I am trying to create a formula based on two criterias ( which keep changing) these then should give different outcomes as follows:

1. For an annual test of level 1 I want the formula to return “false” +

2. For an annual test of level 2 I want the formula to return “1”  +

3. For a Semi-annual of level 1 I want the formula to return “False” +

4. For a Semi-annual of level 2 I want the formula to return “2” +

5. For quarterly test of level 1 I want the formula to return “False” +

6. For quarterly test of level 2 I want the formula to return “3” +

7. For monthly test of level 1 I want the formula to return “4” +

8. For monthly test of level 2 I want the formula to return  “7” +

9. For weekly test of level 1 I want the formula to return “19” +

10. For weekly test of level 2 I want the formula to return “28” +

11.  For daily test of level 1 I want the formula to return “25” +

12. For daily test of level 2 I want the formula to return “45”

 

I used the IF & AND functions and it worked for the first 5(five). I didn’t add in same order as above. As i added the 6th one the formula for item 6 gives false for all criterias. Is the a way to fix this. Here is my current formula:

 

=IF(AND(C2=”one”,D2=”Monthly”),”4″,IF(AND(C2=”two”,D2=”Monthly”,”7″,IF(AND(C2=”two”,D2=”Annually”),1″,

IF(AND(C2=”Two”,D2=”Semi-annually”,”2″,IF(AND(C2=”Two”,D2=”Quarterly”)”3″, IF(AND(C2=”One”,D2=”Weekly”),”19″)))))).   

The weekly one stopped working

By: Jacky

Leave a Reply

Your email address will not be published. Required fields are marked *