Forum Discussion
A LAMBDA Exercise
For this exercise I stripped down a calendar template and put in some sample data. The goal is to obtain gross pay for July for 3 employees. The data arrangement: I believe there are seve...
Patrick2788 Maybe I'm missing some of the challenge but I didn't use Lambda:
=(1.5*COUNTIFS(july,staff)-0.5*COUNTIFS(WkDays,staff)+COUNTIFS(holiday,staff))*8*rateI added 2 Names: WkDays = the range of the month M-F and holiday = July 4
