I am trying to get a result using "=if(and/or)" function. I have to come up with 1 result in two condition within three cell references. If its "MR" or "CAS":

In cell 1 I have the "Year"

In cell 2 I have the "Month"

In cell 3 I have the "Day"

- If a1 = 0
- and a2 <= 6
- and a3 = 0
- then a4 = "CAS" hence "MR"

Somehow, I managed to fix my previous formula with this "=IF(C3>=1,"MR",IF(AND(D3>=6,E3>=1),"MR","CAS"))". However, I received this result. Trial 3, maybe just a little work around and this sheet won't stress me out. hehe. Hope somebody could help. Thanks in advance!

Ideally. If the tenure is exactly 6 months or below the result should be "CAS" but if the tenure comes up 6 months and 1 day the result should be "MR".

Using @user218076 formula. @user218076

1more comment