salary

Dear friends, I have made a salary sheet. This sheet has the months & dates which changes as per the selection of the month. I am facing a couple of problems. 1. How to calculate 1st, 3rd & 5th Saturdays for the working Saturdays. Rest of the Saturdays are holidays with all the Sundays as...

Hi, I have a table (A to D) showing salary changes for staff. Would like to convert it into salary (pro-rated if needed) for 12 months from Apr 2018 to Mar 2019 (E to G). Please help! <tbody> <colgroup><col span="2"><col><col><col span="2"><col><col><col></colgroup><tbody> A B C D E F G...

Hi, I am trying to use Excel to calculate income tax. The tax system has a number of rates applied to each band as follows Lower Limit (H22) Upper Limited (I22) Rate (J22) Tax Free Allowance (G23) £0...

Hi, Not sure if this will be confusing. I have Salary data in sheet 1. Col A Emp Id and Col B Salaries Id Salary 1 289750 2 290617 3 293696 4 293696 5 294941 6 30135 7 305000 8 305913 9 305913 10 307762 11 310464 12 317089 In sheet 2 I have Revised Salary Amount...

Have a problem getting the formula down. I've tried =MIN(January!C20*0.25*0.15) my salary field my % field =MIN(0.15,(January!E3+February!E3+March!E3)/3) The salaries vary. So let's say on a 75,000 dollar salary, the quarterly bonus can pay out no more than 15% or no more than 2,812.50. But...

Hello, I need to build a formula that can tell me that if my salary rank is 2 then i get 2% bonus, but if I work at night I get 1% extra bonus. The way I know i work at night is because there is a column that says N --> Salary Rank Salary Work At Night 2% 200 N math...

Hi there, I have two columns of data. The first column consists of salary and the second column consists of average points per game. There are 147 rows of data. I am trying to choose the top 6 BEST averages while keeping the salary of the 6 chosen to not exceed $50,000. There may be times when...

Hi I'd like to calculated the average salary for employees based on salary bands. The table below shows salary bands and the number of employees in each band. What's the best way of working out the average salary by salary band? I thought about taking the mid-point of the range then...

how to calculate percent rank for employee salary with designation and no of year experienc as condition

Good morning, I am trying to figure out a shorter formula for figuring out what a 2% increase a year would be for the first 4 years and then a 1.5% increase for the final year. I have a value in A1 i.e. 73688 in C1 I have a value from 1 to 5 telling me what the salary increase would be for that...

Hi all, Long time user, 1st time poster :) I have about 700 lines of salary to move into three separate columns (C3, C4, C5) on the right, some of the employee numbers are in the column A more than once, depending on the different rates of pay they get and to do this manually is painful. There...

Hi, I'm trying to calculate the median salary based on a set of conditions - job code = 42, school type = single site. Sample data: <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in...

Hey guys, So I have a list of total monthly salary for each person. The trouble is each person is split among 16 jobs with various percentages. Is there a simple formula to sum all of the salary devoted to each job without building out monthly calculations for each project? My data is arranged...

Hi, My first post and I would request the esteemed members to provide me with a basic Salary Sheet in Excel for my salary calculation purposes. I run a Take-away, online ordering and delivery ******* and my basic requirements for salary calculations are:- 1) CTC 2) Number of days absent. (To...

Hi all! I have a model that helps me calculate a bonus based on hitting certain ratios. I'm having trouble writing a formula to do the calculation. Here's how one line looks: <colgroup><col><col span="2"><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col></colgroup><tbody>...

Hi all, I manage a team of payroll with different salaries. I am looking for a solution where I can input the salary figure in a cell which it is matched against the conditions in the table below to output the correct Levy amount. Does anybody know of an efficient way to do this? Perhaps...

I have two tables, each with two columns: Table 1: Employee ID Number and Salary <colgroup><col><col></colgroup><tbody> ID Number Salary 41 36000 64 96000 153 40000 228 4000 252 72000...

Salary increments will be given once in a year at random times as fixed amount. Increments are given randomly, so if 5000 rs increment is given this month, it should be added to allowances (increases to 14500), so it increases gross salary to 40,000, but next month there won't be any...

<tbody> weekly salary ee er weeks salary 200-339.99 11.9 23.8 4 340-449.99 17.4 34.8 450-609.99 23.3 46.6 610-759.99 30.1 60.2 </tbody> hello so i need aformula to say if my salary is 600 then use ee b3 also multiply ans by d1

Hello everyone, Been some time I've posted here, but this has been bugging me for few days now and i cant wrap my head around: Problem: i have employees salary data and i have market max/ave/min salary data. 1. make stacked floating chart for market data and put scatter points per categories...