View Single Post
Old 9th September 2015, 01:22 AM   #285506  /  #20
nostrum
too boring to be considered weird
 
nostrum's Avatar
 

r: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; } table.sample td { border-width: 1px 1px 1px 1px; padding: 1px 1px 1px 1px; border-style: inset inset inset inset; border-color: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; }
Tag=IFERROR(IF(OR([@recruit]="y",VALUE(MID([@[CSOF_Y0]],5,1))>7),[@[CSOF_Y0]], INDEX(salary[For step or reclass],MATCH("step"&[@[CSOF_Y0]],salary[inc lookup],0),)),[@[CSOF_Y0]])


r: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; } table.sample td { border-width: 1px 1px 1px 1px; padding: 1px 1px 1px 1px; border-style: inset inset inset inset; border-color: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; }
Tag=SUM(INDEX((stafflist[Program]=D$8)*(stafflist[Y0$]),0))+SUM(INDEX((stafflist[Program]=D$8)*(LEFT(stafflist[EmpGroup],4)="Inde")*(stafflist[FY term]="Y0")*(stafflist[Term$]),0))-SUM(INDEX((stafflist[Program]=D$8)*(stafflist[FY commenced]="Y0")*(stafflist[Recruit$]),0))-SUM(INDEX((stafflist[Program]=D$8)*(stafflist[term ext end]="Y0")*(stafflist[term ext $]),0))


and these are just a couple of ones in a little old something I am updating right now

__________________
I thought I was in a bad mood but it's been a few years so I think this is who I am now
nostrum is offline   Reply With Quote topbottom