=IF(EmployeePerformance=”Excellent”, “More Work, Same Pay”, “Same Work, Less Pay”)
=CONCATENATE(“Dear”, ” [EmployeeName],”, CHAR(10), ” We regret to inform you that”, CHAR(10), “No increment for you this year.”)
=CHOOSE(MAX(MIN(1,ROUNDUP(CompanySales/50000,0)),6),”Boss is Confused”,”Boss is Grumpy”,”Boss is Meh”,”Boss is Satisfied”,”Boss is Happy”,”Boss is Ecstatic”)
=CORRELATION(EmployeeEngagement, CoffeeConsumption)
=IF(OfficeEvents=”Team Building”, “Forced Fun Time”, IF(OfficeEvents=”Performance Review”, “Anxiety Overdrive”, “Cake Day”))
=COUNTIFS(TeamMembers, “Swifties”, TeamMembers, “Coldplayers”)
=XLOOKUP(EmployeeName, TeamMembers, TeamRoles, “Lost in the Matrix”)
=ROUNDUP(TaxDeductions,0)
=MAX(Bonus, Expectations)
#Dugaan #ExcelinExcel #BebelBimbo
Excel with Me @Sim Ling KU
P.S. If you didn’t quite get it, then maybe you’d like to consider brushing up your Excel skills by signing up courses like this one: https://cad.cadtraining.com.my/excel-video-slk 😉 #JustSaying
