salary

I need some formula or vba code to get the desired output. Formula should check column D if a cell in column D starts with "0" then concatenate all rows in column L (with spaces) until another cell in column D that starts with "0". Red highlighted cells are the garbage that are produced by the...

Hi, I need to put a formula in Column M which will search through column L and match it (partially or completely) with column O and display the value available in same row in column P. If VBA code will do it faster then provide VBA code please. e.g. in Column L, it is written as "Salary of...

I am looking for an IF formula for...number of severance weeks based on salary grade level...for example: IF grade level 21-25 receives 10 weeks of severance @ [amount] (based on individual salary) IF grade level 26-27 receives 12 weeksof severance @ [amount] (based on individual salary) IF...

Hi I will find the average salary using =average(D2:D8). What I also want to know the names of people who make more than average and the names who make more than average. How can I do that? Thank you =average(D2:D8) <tbody> 54787.57 </tbody> <colgroup><col width="64" span="4"...

Hi all, kindly advise me so that to create a VBA code which should “SUM” the headings and rows down in columns “SALARY” & “ACTUAL SALARY”. Therefore, that the above headings have no stably column, but the row “2” is constantly. Below I present the original data and the expected result...

Hi I have table like below, so I wrote vlookup function. user will enter id # and vlookup will return the salary. the vlookup function works no problem. then I tried to enter id = 100 which is not existed in the table, vlookup returned to me the last salary 17K. I tried different ID not existed...

Hi friends I want to add salesman bonus in the salary,but if target not achieved i want to show his actual salary instead of false. thanks see below image [COLOR=#574123]

I have list of data with 4 columns: 1. number identifier: say a1,a2,a3 2. description: say salary, bonus, overtime, misc 3.amount: $500,$100,$200,$250,$25 4.type: sales, admin,shop, I would like to extract data based on type, say under type, I have a category "sales", I would like a formula...

Hi I have a file called AllEmployees.xlsx which has one sheet called ALL and inside that sheet an empty table with only labels as below. I have 3 other excel files sales.xlsx, marketing.xlsx and hr.xlsx, each file has one sheet (sales, marketing, hr) and each one has one table as below. I want...

Hi If someone can help If the words "Part Time" or "Casual" is found in M17 then AZ17*Y17 but if "Salary" is found in M17 use the value in AZ17. Thanks for any assistance Stephen

Hi Mr Excel, I've literally spent 3+ hours on Google but still can't solve the query below. The code below works perfect, it gives me all the employee names ranked by salary. Current Code...

I have a document I had the if and then statements in excel but I was messing them up yearly because it is based on years of service. I want to do it as VBA, so it will calculate automatically without having to do anything. The columns I have are YTD salary, hire date, the year (to calculate...

Hi I have a table like the one below. I want to calculate sub total, sub salary etc. So I selected cells beside the table and wrote subtotal functions. But the problem When I filter any column, I might lose these cells as well (total count, total salary, min, max, average). How can I avoid that...

Hey, guys, I'm aware its possible to use vlookup to search in a range. However, let's say you only have the maximum limit. For the purpose of example a have column A with amount and column B with percentage. Column A figures represent salaries: <tbody> A B 632 0% 645 3% 683 5,7% 736...

Hi Everyone I am looking for the best way to arrive at the overall percentage increase of the salary figure [B2:B5] applicable to people based on their employment start and end date (let's assume all still employed). If a person was employed at a given 6 April [A8:A12] an increase applied...

How can I create a formula for this Calculation in Excel 76% on first $1,250 of Salary + 54% of following $3,750 + 45% of the remaining to a max. Of 8000$ or 85% of Salary whichever is less. I appreciate any solution for this.

I have these job levels (in order) with their corresponding average salaries, earlier job level salaries, difference in $ and % between the two. This is a manual table, and I need a DAX formula to calculate the earlier job level salary so that I can calculate the differences, but I can't for the...

Hi , I am making a format of salary slip using index and match function. i am trying that if i put the month and emp. id the rest data should come automatically to that payslip format. but i have 12 worksheet having 12 month salary on it. and in that i have already made table of the salary made...

Hi all, I am trying to forecast hourly teachers salary for the rest of the year. This particular teacher works 32 hours per week, 45 weeks out of the year and paid hourly wage of $20/hour. How do I write a formula so that it calculates monthly salary for the whole year. This teacher does not...

Hello dear professional friends, Can any one give me a formula for making a salary sheet where say from 3-jan-2017 to 20-apr-2017, monthly salary is 2000$ so first 29 days(as inclusive) to be calculated as 31 days in a month and in april 10 days to be calculated as 30 days in this month. I need...