jawaharprm
New Member
Hi Team,
Please help to create slab agints Time & AON, if calculated time meets Aon given criteria should be tagged as "YES" in new coloum
1. if Criteria meets In "C" Coloum <=36 hours and in G Coloum <=2 shoud be update as Yes
2. if Criteria meets In "C" Coloum <=32 hours and in G Coloum <=5 shoud be update as Yes
3. if Criteria meets In "C" Coloum <=30 hours and in G Coloum >5 shoud be update as Yes
Sample file has enclosed for your reference..
Thanks
Jawahar
Please help to create slab agints Time & AON, if calculated time meets Aon given criteria should be tagged as "YES" in new coloum
1. if Criteria meets In "C" Coloum <=36 hours and in G Coloum <=2 shoud be update as Yes
2. if Criteria meets In "C" Coloum <=32 hours and in G Coloum <=5 shoud be update as Yes
3. if Criteria meets In "C" Coloum <=30 hours and in G Coloum >5 shoud be update as Yes
Sample file has enclosed for your reference..
Thanks
Jawahar
Attachments

9.9 KB Views: 3