000

Dear All, I'm struggling with Sumproduct formula to calculate bonus based on percentage budget achieved (see below). My desired amount Column U and the formula I'm trying to implement in Column T. If % Budget achieved is 100% then you expect 7.5% Bonus, $7,500 (100,000*7.5%). If you achieved...

Column A, cells A1, A2 etc have values in it. i.e. 525000 675000 etc. In cell B1, B2 etc I need to know how to get 7% of the first 100,000 and 2.5% of the remaining amount I.E 525,000, 7% of 100,000 plus 2.5% of 425,000 675,000, 7% of the first 100,000 plus 2.5% of 575,000 I can do it in two...

Need a macro that multiples the value in a cell by 1,000. Sometimes the cell value is a positive amount, other times it’s a negative amount. If a cell has a value of 8, I recorded a macro that does F2, *1000, then home, then +. The macro works fine and returns 8,000. But when the cell has a...

$1,000 grows to $1,000,000 in 200 periods at what interest rate? thanks :confused:

Hello, I have GL data that basically looks like this A1:GL Acct # B1: Name C1: Total D1: Department 1 E1: Department 2 F1: Department 3 A2: 65000 B2: Wages C2: 1,000,000 D2: 500,000 E2: 250,000 F2: 250000 A3: 79000 B3: Travel C3...

Hello, I'm wondering if there is a weigh to "weight" my y axis on an excel chart. I have many points that fall in between $0 and $1,000,000, fewer that fall between $1,000,001 and $10,000,000 and very few greater than $10,000,000. So, I would like the points that fall in between $0 and...

Hello, Using Excel 2016, I have a sheet with over 100 columns. I put a filter on it so I can quickly review each column for bad data, but I get a message a the bottom of the drop down saying "Not all items showing". When I click on it, I get a message saying "This column has more than 10,000...

Hi Im trying to build a calculator that calculates a blended fee based on the constraints below. For example, if X client has $10 million to invest - his fee would be:? <tbody> <colgroup><col><col><col></colgroup><tbody> Investable Assets $ 10,000,000.00 Blended Fee From To Rate...

Good Afternoon, Does anyone know of a way to distribute a certain number (say 25,000,000) over a group of non-contiguous cells, while adhering to a floor, or minimum number, for each respective cell? Also, formulas in the past have been "biased" toward the upper-most positioned cells (so that...

Hi, I needed help and appreciate if someone could help me. Suppose the "search key" is 2 Feb 2019, and: Column:A Column:B 1 Feb 2019 $1,000 2 Feb 2019 $2,000 3 Feb 2019 $3,000 How can I use VLOOKUP, or any other formula if needed to get "$2,000"? Thanks...

Problem: In Google Sheets, I use the IMPORTDATA function with an API call to a 3rd party data provider that frequently produces a text string that is longer than the cell limit of 50,000 characters. I have no control over the length of the text string that is provided to me, and when the...

Hey All, Quick question, I'm trying to calculate an ongoing IRR calc for a Private Equity Investment. For every period, I want to have an IRR calc up to that point. I need to somehow bring in the Fair Value of the fund on that date into the last cash flow of the IRR calc, otherwise the Cash...

I'm trying to build a table that lists a broker's volume from largest to smallest (top 10 firms only). If there are only 9 values in the data set, a zero will appear in the row. To grab the volume, from largest to smallest, I'm using =LARGE($B$2:$B$63,1), =LARGE($B$2:$B$63,2)...

Hi Gurus, Can somebody help to put the IF nesting formula together, please? I need to put the following figures in IF NESTING: Income Offset up to $37,000 $255 $37,001 to $48,000 $255 plus 7.5 cents for each dollar over $37,000 $48,001 to $90,000...

Hello I have the following set of data I would like to like to do the following: Total the values in Annual Peak KWh* for each state so e.g There are 2 rows for VIC with 180,000 in each row so the total would be 360,000 1 row for QLD = 200000 What is the formula to create to do that for...

I have a list of POs in sheet 1 contained 20 columns with its information and date is in column F. I need list of more than 3 months old POs in Sheet 2 from row 2, in A1 Date with formula =TODAY(). Please help with formula Sheet 1 Supplier No. Supplier Name PO No PO Type Date...

Hello, I want to build a simple sheet to manage inventory for rental business with 3 warehouses. Items can be pulled from, and return to any warehouse. When the quantity of items is entered, I want some kind of button to appear where I can choose which warehouse the items will pull from...

Is there a formula or conditional format you can use to extract and string from a cell where the string is always a certain number of characters. I have a spreadsheet where the cell includes the VIN for an auto but the VIN is always 17 characters long. The problem is there are other items in...

Good morning I am creating a spreadsheet that needs the following and I'm having trouble creating this formula. I earn commission and I am charged a specific percentage of my sales until I reach a specific sales volume number , say 15% and charged a different percentage once I reach another...

Hello Board, I have just taken over a workbook and on checking it, I can see there are around 90,000 cells that have links out to data in another workbook. is this the best was to have one workbook update another?