Help in Excel formula

[jawaharprem]

Hi,

i need a help in excel formula that based on AON...

Employs Tenure
<2 Years tat should be 36 hours
<5 years tat should be 32 hours
>5 Years tat should be 30 hours

i have completed AON Slab "=IF(AJ2<=2,"<2 YRS",IF(AJ2<=5,"<5 Yrs",">5 YRS")) & TAT reached "IF([@Time]<=36,"Yes","NO")"
is there is any method to add the above mentioned criteria in this please help on same.

Thanks
Jawahar

 

[Sufiyan97]

I did not fully understand what you are trying to achieve
Try below and let me know is that what you want?

=IF(AJ2>=5,30,IF(AJ2>=2,32,36))

 

[jawaharprem]

Hi Thanks for your time.

i done this formula

=IF(OR(AND([@[AON LAB]]="<2",[@Time]<=36),[@Month]<8),"Yes",IF(OR(AND([@[AON LAB]]="2 to 5",[@Time]<=32),[@Month]<8),"Yes",IF(OR(AND([@[AON LAB]]=">5",[@Time]<=30),[@Month]<8),"Yes","NO")))