If condition for a range

[Balajisx]

Hi Team,

please help me in finding the formula.

I have uploaded a sample file which contains the Quality score of the employees. I want to find out the below

QIP 1 - if the agent quality score fall below 95 % for consecutive 2 weeks then he will be in QIP 1

QIP 2 - if the agent quality score fall below 95 % for consecutive 5 weeks then he will be in QIP2

Call to Action : if the agent quality score fall below 95 % for consecutive 9 weeks then he will be in CTA

 

[NARAYANK991]

Hi ,

What are we supposed to take blank cells as ? Above 95% or below ? Or ignore them ?

Narayan

 

[Balajisx]

We can Ignore the blank cells

Thanks,

 

[Balajisx]

Hi NARAYANK991,

any updates on the above request?

regards,
Balaji S

 

[NARAYANK991]

Hi ,

I will take some time , since I am tied up at present.

I hope someone else looks into this , if you are in a hurry.

Narayan

 

[Balajisx]

No problem.. Appriciate your support.

Thank you!

 

[Balajisx]

Dear Team,

Can some one help me on the above request please.

regards,
Balajisx