000

Hi all, Please help me with formula which calculate weighted average selling prices (WAP) based on volume Sheet 2 result <colgroup><col><col></colgroup><tbody> <colgroup><col><col></colgroup><tbody> Product No. WAP 22-400 17.05 22-500 27.22 22-100 20.00...

I need to calculate based on the below chart but coming up with a negative # (I understand why) but can't figure out how to get an additional if statement to resolve or is there a better way to calculate <tbody> Fund Balance $750,000 Up to $499,999 2.25%...

Hi I'm trying to create the following formula for a sliding retention calculation based on an invoice amount as follows:- 1. If the current amount invoiced is less than $200,000 retention value is 10% 2. If the current amount invoiced is between $200,000 and $800,000 the retention value is...

In Sheet1, I have a list of 100 Dynamic IDs in Column D. Starting from D11 to D111 In Sheet2, I have a database of about 20,000 rows. Each ID ( from Sheet1 ) will appear only once in Sheet2.ColA. Need a VBA to delete rows, where the value in Column A is NOT equal to any of the 100 ID. In...

I have a row in excel that calculates commissions. Once the total gets to $8,000 (B6 in the below example), I want the formula to no longer calculate commission. Commission should be zero. What formula do I put into the B column? Whenever I do an IF formula, I get a circular reference because I...

Hello, I have a spreadsheet with lots of columns. Some columns need items counted and some need items added. I'm hoping someone can help me with code to count and add cells in a column after the last occurrence of a series of items. Let me explain with an example. The code would start with Col...

Hello everybody! (HI DR. NICK!) I'm after a semi-intelligent automated solution to a manual task one of our directors does, he goes through a list of 1,000 clients each week and assigns a brand to them based off a bunch of variables and calculations he performs -imperfectly- on the spot. On...

Im trying to create a formula with the following parameters: lets say you have: 1,000,000,000: and you get: $1K for each $1mm (Gross) up to $50mm $0.75K for each $1mm (Gross) from $51-$150mm $0.5k for each $1mm (Gross) from $151-$500mm $0.2k for each $1mm (Gross) from $501mm-$750mm...

I am trying to put the same monthly revenue into the correct months based on a start date and end date. I have the formula to equally split the revenue over these months but I would like to have the same number in each box. I have attached what I currently have and an example of what it should...

Hi all, I am not an advanced user of Excel by any means and am struggling to create a formula for calculating sliding scale sales commissions. I'm the manager of a real estate office and require a formula to assist with automatically calculating the commission payable to an agent based on their...

Dear Community I am hoping someone can help me. In the attachment, I have costs which are phased depending on when we start. Row 2 £84,000 is split from April to October by judgement assuming a normal distribution manner, starts off high, peaks and then tails off. Is there an Excel formula...

Hello is there any way to fix below formula? I placed the formulas by the columns J & K all the way down. If column C datas are the same numbers my formula doesn't find two differnt names... Many thanks. <colgroup><col><col></colgroup><tbody> COLUMN B COLUMN C Name 1 12,000 Name 2 12,000...

Hi I think I have created my spreadsheet incorrectly as I am trying to create a trend analysis comparing one financial year to the previous year, but also over a period of 12 months (hope that makes sense. I have tried the Insert Line Chart and that's having a fit <tbody> Name Jan 2017 Jan...

Hi Experts, I have a sheet which runs into over 30000 rows. I need to find contra entries within a company in column B for a each job in column C. Basically I need to find which transactions sum to 0 in column K (Balance in Base). so for example, in company code IN9073 in column B, there are...

Hi, I have 90,000 rows in a spreadsheet, some are blank and some contain text. I want to copy all 90,000 rows for the column to another spreadsheet, but when I paste it in the other spreadsheet, only about 1200 rows get pasted, and the rest do not. Does anyone know why this is happening and...

Column A3 is a basketball player's name, B3 is his salary for the day and column J are his projected stats for the day. I need to find the top 8 scores of column J that equal $50,000 from column B3. I also need their names (from column A3) associated with the results. The results can be placed...

What I am looking to do is display 2 numbers in one cell. Data Example - F80001 = 16 D80001 = 35 Goal for it to look like - 16 / 4.571% / Right now it looks like - 0,016 / 4.571 Here is the formula that I am using =TEXT(F80001,"0,000")&" / "&TEXT(F80001/D80001,"0.00%")*10 Thank you!!!

Hi all , in cell B56 i have 13,857 which is a sum of B2:B53 and im looking to split this down into 10,000 into cell B58 then the remainder into cell B59 . Any ideas on what function i would use to do this? Thanks!

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...

Hello, Please help me with given sample tables below. First table shows the original datas... Second table is the results what I wanted to get by clicking the button all datas will randomly changed with below conditions. 1. Column A and Column B will be related datas.(If A1 goes to another row...