casual

<tbody> Month Emp # Opening Casual Leave Availed Casual Leave Casual Leave Balance Sep 18 1 05 01 04 =(C1-D1) Sep 18 2 07 02 05 =(C2-D2) Oct 18 1 04 ? auto fill Oct 18 2 05 ? auto fill </tbody> how to opening casual leave auto fill while entering new month payroll?

Hi Have below that is supposed to work if "Casual" or "Part Time" is found as part of text in I17 but will only work if perfect match? If Casual is found then it works but if "Casual after 3 months" it does not. =IF(OR(I17="*Casual*",I17="*Part Time*"),AF17*AA17,AE17) Any help would be great...

Hi In AT4 I have =SUM(AR4,AQ4,AL4,AI4,AE4) BUT is only SUMMING AO4,AL4,AI4,AE4 and not AR4 All cells are formatted number so no problem there But in AR4 I do have the formula =IF(OR(M4="Casual",M4="Part Time"),AD4*Y4,AC4) and in M4 "Salary" is found not Casual or Part Time. So appears to be...

Hi I have below that returns the value in S21 if "Casual" OR "Part Time" is found in "M21" =IF(OR(ISNUMBER(SEARCH("Casual",$M21)),ISNUMBER(SEARCH("Part Time",$M21))),S21) If either of those words are NOT found then returns a FALSE. I need to return a "" blank cell if anything other than Casual...

Hi Have a little issue and need a formula for below. If the word "Salary" is found in G4 divide H4 by 40 but if "Part Time" or "Casual" is found in G4 use value in H4. Any help would be great. Thanks Stephen

I have 2 sheets of data in a workbook as below: Sheet source: <tbody> Category1 Category2 July August sports apparel 9 11 sports accessories 6 14 sports other 23 15 casual apparel 15 19 casual accessories 20 17 </tbody> Sheet Destination: <tbody> Category1 Category2 July August...

i would like to do conditional formatting between a range of dates <tbody> <tbody> August 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31...