000

  1. B

    Sumproduct Tiered % Bud Achieved Bonus Twist

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

    Another Newb question

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

    Macro to mulitply a cell by 1,000

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

    Calculate interest rate

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

    Vlookup/Hlookup need help

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

    Gradient Y Axis

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

    Filter only displays 10,000 unique items

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

    Blended Fee Calculator

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

    Randomly Distributing A Pre-Determined Sum Over 12 Non-Contiguous Cells

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

    How to VLOOKUP specific month and year to find a value?

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

    Google Sheets: Scripting Workaround for 50,000 Character Cell Limit?

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

    Private Equity IRR Calc

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

    Vlookup unable to return the next cell that meets criteria

    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)...
  14. K

    Calculate a cell value based on a different cell value

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

    Sum a column based on an IF Statement

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

    List of more then 3 months old Purchase Orders (PO)

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

    Buttons to run formulas

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

    Extract string of text from a cell that is always an exact number of strings

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

    Commission sum of question

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

    External Links

    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?

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top