deduction

Dear Excel wizards, I am trying to find an Excel non-VBA formula to automatically calculate the end-of-year holiday week based on the available yearly data. These are the holiday data (including the 25th of December and the 1st and 2nd of January the next year): Monday 26 - Friday 30...

How To Set deduction cumulative percentage from 01/08 to 30/08 If employee late in arrival more than day and finish this work If attendance in 02/08 is 08:30 is deduction is 10% And attendances 03/08 09:15 deduction is 30% need to be 10 + 30 = 40% and do that for all month date...

Hi, I am having trouble working the logic for the below scenario:- I am aiming to achieve a workbook that will automatically tell me what deduction to make if time between two dates is under 2 years (100%), 2-3 years (75%), 3-4 years (50%) and over 4 years (0%). I have a workbook with a list...

Hello, I am looking to create an Index/Match (open to other suggestions) that would based on a specific section of cells based on a conditional match. In example below, John Smith has pay/deductions designated to Department 200 and 201. If I'm looking for the Tax 2 amount for John Smith in...

In "b2-B40" I have cells that have background color as yellow and is a 3 point deduction for not meetin Kpi, if background color is red than 7 point deduction for not meeting Kpi. In b50 would like code to calculate score by deducting Kpi error points from 100. Thanks for help,

Hi everyone, I appreciate you looking at my thread. I'm still new to this excel thing, and I've only just started getting my hands dirty with this program and it's quite addictive. Ok so now here's what I need to accomplish: I have a form where my Team Leaders order totes of product that we use...

Hello, I have this spreadsheet at work that I am attempting to add some macros/formulas to so that it does some processes automatically. I have come up with a few solutions, but I am stuck on one problem at the moment. I have figured out how to automatically pull out the initials of the...

Hi Guys :) I do these days an analytical research and i need some of help in this issue I need to find a way to extract the prime factors of numbers with some special conditions .. Let's take an example to make it much more clear IF i have an an integer number .. let's say 12682 I want to...