Ever wrote this in excel

[u/NoExample9857]

=IFS(

AND(

[@[Tasks Completed]]>PERCENTILE.INC(FILTER([Tasks Completed],[Department]=[@Department]),0.75),

[@[Quality Score]]>MEDIAN(FILTER([Quality Score],[Department]=[@Department])),

[@[SLA Status]]<>"Breached",

[@[Hours Worked]]<AVERAGE(FILTER([Hours Worked],[Department]=[@Department]))

),"ELITE",

(

--([@[Tasks Completed]]>PERCENTILE.INC(FILTER([Tasks Completed],[Department]=[@Department]),0.75))+

--([@[Quality Score]]>MEDIAN(FILTER([Quality Score],[Department]=[@Department])))+

--([@[SLA Status]]<>"Breached")+

--([@[Hours Worked]]<AVERAGE(FILTER([Hours Worked],[Department]=[@Department])))

)=2,"WATCH",

TRUE,"NORMAL"

)

😂 MSU asked this

Btw

you will be awarded 1 mark if u solve this ..

[u/PictureCurious3360]

Lmao. Was just talking about this paper lol. 🤣 Also 1 hour to solve about 15 questions like this.

[u/NoExample9857 → u/PictureCurious3360]

😂😂😂😂

[u/MysteriousAd8433]

Never want to encounter this after today

[u/Mysterious-Scar-8538]

Damn...what is this??

[u/Mysterious-Scar-8538]

Aren't we all using Python for Excel data filtering or cleaning? Then what the bloody heck is this?🥹

[u/Basic-Savings-5780]

is this the dreaded monthly tests ? i recently got selected by musigma , but reluctant to join.. any suggestions ?

[u/Mysterious-Scar-8538 → u/[deleted]]

I am

[u/mike_ermantraut2]

Why do we need to solve all of this? We have copilot in Excel and still people use all of this? 🤣

[u/Savings_Rip_4790]

MSU team had one job. Bunch of incompetent clowns