Is it always zero for part-time employees? If so try this formula in E3 copied down
=IF(D3="F",LOOKUP(DATEDIF(C3,TODAY(),"y"),{0,1,2,9,16;0,40,80,120,160}),0)
Is it always zero for part-time employees? If so try this formula in E3 copied down
=IF(D3="F",LOOKUP(DATEDIF(C3,TODAY(),"y"),{0,1,2,9,16;0,40,80,120,160}),0)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks