# 000

1. ### 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. ### 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. ### 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. ### Calculate interest rate

\$1,000 grows to \$1,000,000 in 200 periods at what interest rate? thanks :confused:
5. ### 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...

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

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?

### This Week's Hot Topics

• Check VBA code to locate value in cell
Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
• Reverse Numbers Formula
Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
• Count If Issue
Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
• VBA Check for multiple cell values and copy the cell in column A
Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
• Sending mails to specific recipients based on a cells value
Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
• Matching Number in Textbox
Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...