salary

Dear All, I used office 32-bit but our PC changed to 64-bit. I need your help and code is below. If you put additional code, it will be good. I appreciate your help in advance. <colgroup><col></colgroup><tbody> Private Declare Function ShellExecute Lib "shell32.dll" _ Alias "ShellExecuteA"...

I need help showing only columns based on criteria. I have a spreadsheet with Q1, Q2, Q3 and Q4 data. If I type "Q1" into a specific cell (in this case cell C2 which is shaded) I want all of the cells containing Q1 at the top to appear and all of the cells that contain Q2, Q3 and Q4 to be...

Hi I am trying to use rank but it does not make sense how rank() function is ranking numbers. in the example below. why for example 96332 and 96103 both have rank #1 !! should not be rank 1 and 2 respectively? thanks ps: the function i wrote is =RANK(B2,B2:B25) then autofilled <tbody> salary...

Hi, I am trying to learn how to use index match function when there is multiple variables. I am getting NA error below is the screen shot can somebody explain where i am going wrong and what i need to be careful when i am using the formula. I am using ctrl+shift+enter to sun this formuls...

I have a data table of dates, first names, surnames and salary. I need to be able to lookup the salary on or before a given date. I need to do this multiple times so do not want to use the Control Shift Enter array construct. Any suggestions for a single line formula that can deal with the data...

Calculate pay day I get paid on the first of every month. When this falls on a Saturday or Sunday I get paid on the previous Friday. But when this falls on a Bank holiday I get paid on the previous working day. How do I calculate my pay day?

Hi, I hope this makes sense.....:???: I'm trying to calculate the median of salaries that meet a set of criteria. I've looked at other threads, and tried the {=Median(if(A1:A16=criteria,B1:B16))}. This formula works, but it's not returning the median I'm looking for. For example, I want to find...

Sir, I am getting 12 lakh rupees annual salary. While paying tax, for 1st 2.5 lakh tax is nil. For next 2.5 lakhs 5% tax i.e. 12,500. For next 5 lakh, 20% tax i.e. one lakh. Above 10 lakhs, 30% tax i.e. 60,000. So, I pay 0 + 12500 + 1 lakh + 60000 = 1,72,500. How can I compute through a formula...

Hi I created pivot table like this <tbody> dept salary sales 10 admin 20 hr 30 </tbody> Then I inserted pivot chart - Pie chart. everything is fine so far. Now when I insert City as a column in the pivot table (see below) then the Pie chat wont work anymore. How can I fix the pivot...

Hello, 1. Salaries are reported annually. However, they can change each month. 2. Bonuses are paid irregularly over different months. I am trying to achieve: Show in the table "Yearly Salary Vs Bonus" the correct results for Salary and Bonus while selecting a specific Month. OR if Selecting...

Hi all, Finishing off budgets and just been asked can I split out salary in an entirely new way. I am hoping that there is a way I don't know about. Thanks Dara <tbody> <tbody> Employee Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Product A Prodcut...

Working on a budget project. I have a list of departments within our organization, and the corresponding general ledger accounts. ("Source" tab) I need to create a worksheet for each of these in a workbook. The worksheet needs to be named Department - G/L number. Also, I have a list of...

How to tell following criteria in if function Employees who are in grade 1 are subject to 1% of basic salary Emoloyees in grade 2 are subjected to 2% of basic salary Employees in grade 3 are subjected to 3% of basic salary Calculate the service cost for each vehicle using the “Logical IF”...

Hello! Merry Christmas to all! I have a report to submit on Wednesday. I have tried all weekend long to solve this with no luck, thus I'm here hoping someone with more experience has any hints. The report requires the calculation of the median as one of the measures for a Salary/Wages...

Sir, I have my present salary in Col-B and new (fitment range) salary in Col-C. If Col-B matches with any one of the fitment range cells of Col-C, new salary will be the present salary. Else, my new salary will be fit in the next higher cell of the fitment range. I want to show my new Salary in...

Sir, I've a column(A) having months from January 2014 to January 2018. In column(B), I have my salary. Every year in June, I get an increment of 100 rupees which is added to my salary. if in January 2014, my salary is 2000, from June 2014, it is 2100 till May 2015. From June 2015 to May 2016, my...

Hi All, I have a main tab and within it I have column A that list salary ranges as follows: £1000 - £2000 £2001 - £5000 £5001 - 10,000 £10,000 + Within "salary tab I have a list of 40 people who each fall into one of the criteria above based on the "salary" filed which is in "F" of the...

Alright, Excel gurus, I could use your help. I've got a bunch of survey results, and I'm expecting lots more. I'm creating a calculator in Excel to run some numbers for me faster. The main problem I'm running into is that the result I'm ultimately looking for is an average salary amount. When...

Hi I have pivot table like the one below City Name as row labels and Salary as value, then I put Salary as value again but then changed "show value as:" From Largest to Lowest. Now when I try to create a chart from that table, I went to Option-->Pivot Chart and I selected Bar chat. The problem...

I am trying to create a formula in excel to give me a monthly premium amount for disability coverage. I have current age in one column and annual salary in a other column. I need to take annual salary divided by 12 months then divide by 100. Monthly salary cannot exceed $6000.00. That part is...