# fees

1. ### Tiered bonus structure

Trying to setup a spreadsheet to do this but here's the grid below. Bonuses are ONLY given on the amount between the threshold. For instance, if you do 500K of commission and fee's, you get a bonus on tier 1 on 99,999 of production, then you also get a bonus on the 299,999 of production. You...
2. ### Help with VBA to return values to given cells

Hi everyone, I have a worksheet called "Fees Paid" that holds members names and other values, In cells "A through to J" Then i use another worksheet called "MembersReport", on the worksheet i use Vlookup formulas to return matching values from "Fees Paid" worksheet to certain cells in the...
3. ### reformatting data extract

folks, i need to reformat a report extracted from our ERP. the report gives me accommodation revenue by fee type for each particular room type. if printed from the ERP, the report is formatted to print each accommodation class on new page with a column for each fee type. The number of bed days...
4. ### Delete Row Using Filters with a Macro

Hello: I created a macro to reformat the following spreadsheet. Column N (Resulting Current Projection) is a formula of: L + M. The formula only needs to be added to any row with code "R" from column B. The problem I am having is that even though I filter code R, the formula carries down to...
5. ### Formula for calculating eBay selling price

Hi folks, I'm not sure if this has been posted before or if there is a guide on how to do this on this forum, so apologies if there is. I want a formula which I can use to work out my selling price on eBay, assuming I want to make a 15% profit of the selling price, and the following are my...
6. ### Sumproduct and if statement

Is it possible to use sumproduct and if statements together, or is there an easier way of achieving what I need to do here? I have the following formula: =SUMPRODUCT(--(Statement!\$J\$1:\$J\$1724=C13),Statement!\$L\$1:\$L\$1724) What this does is look at my bank statement sheet for a particular line...
7. ### VBA Finding a Term on a Hidden Sheet and Loading the Individual Fees to a Userform

Good Afternoon, I have a vba problem I just can't wrap my head around and I'd appreciate any help. I've thought about using index/match, vlookup, or find, but I just get confused the more I think about it. The ultimate goal is to have a user double click a term which opens a userform and they...
8. ### How can I determine multi-level value fees from a table of fees for a given value?

HI Guys/Girls I need to change my formulas and/or lookup table structure to calculate a new fee structure bring implemented in July by eBay. I need to determine multi-level value fees from a table of fees for a given value. Reader background info If you look at the Research Tab This is used...
9. ### Should I use Index/Match?

I have a dashboard where col B is academic terms and col D is their total fees. I have a hidden sheet with the breakdown of their fees that I want to load on that multipage. When a user double clicks a term in column B a multipage in a userform pops up. So if Semester 1 is double clicked the...
10. ### How many userforms can excel handle?

Long story short I'm still about one years old using VBA and I'm making a spreadsheet with multiple semesters in column A. In column B is tuition, and in column C is fees. I just started making this so I haven't gotten very far, but I currently have it set up where when you click on cell C1 a...
11. ### Sum the values across multiple sheets by category

Hi guys I've read a few posts on how to sum values across multiple sheets meeting a lookup criteria. None of the threads I've encountered have explained it this noob. I've tried the ExcelJeanie without luck, the version is incompatible with the Excel I am using. The data below is comma...
12. ### Sum the values across multiple sheets by category

Hi guys I've read a few posts on how to sum values across multiple sheets meeting a lookup criteria. None of the threads I've encountered have explained it this noob. I've tried the ExcelJeanie without luck, the version is incompatible with the Excel I am using. The data below is tab delimited...
13. ### Lookup multiple values in the same column (I think this is what I'm looking for)

Hi everyone, I'm quite new to excel and have been trawling the internet and YouTube for answers but couldn't find what I was looking for exactly. So I have a transaction sheet from Amazon for accounting purposes. All I want to see is how much I had made per item. However, the way Amazon show...
14. ### Temporary files now being 'read'

We have changed to a cloud server recently, which may be causing the problem, but has anyone come across this before? I have a folder with a "- Fees" workbook and a workbook for each member of staff. When the fee workbook is opened, it takes data from each of the workbooks in the folder, apart...
15. ### Combining Formulas

Hi We have originally added fees to accounts based on a percentage of the original balance. We have a new client who wants their fees capped to specific amounts. I've done the formula for the new cliwnt but I'm struggling to add the equation to the original equation. The data looks like this...
16. ### Calculation of fees based on bands

I have to calculate fees based on different bands, for example ( first 2000, next 3000, next 5000 etc) see image below, I need help to resolve this . See file at the link below https://drive.google.com/open?id=1lwt6O8v32yC1WcH7VGQ4_R6qoBeAT2ix Please help Regards
17. ### Excel counting formula

<tbody> STUDENT NAME CLASS ADMISSION NUMBER FEES PAID NAVEEN LKG 4001 5000 KANNAN UKG 4002 8000 NAVEEN LKG 4001 2000 KARTHIK 1 ST 4003 12000 RAVI UKG 4004 9000 </tbody> I WANT TO GENERATE A REPORT LIKE BELOW, <tbody> CLASS NO OF STUDENTS ADMITTED TOTAL FEES...
18. ### Tier Fee Equation

Hi - Can anyone help me figure out how to calculate total gross on the table? I would like it to calculate \$100,000 in first column, \$22,500 in second, and \$20,000 in third. <colgroup><col width="206" style="width: 155pt; mso-width-source: userset; mso-width-alt: 7533;"> <col width="143"...
19. ### Use OFFSET/INDIRECT/INDEX/MATCH (or any combo) to find value across multiple worksheets

I want to prepare a SUMMARY page that finds a corresponding ITEM# on the Summary page within the other 6 worksheet. The ITEM# will appear on ONCE on a single workbook and they will NOT be in alpha/numeric order (so LOOKUP/HLOOKUP/VLOOKUP won't work). The formulas needed will need to match the...
20. ### Formula for Changing % Allocations

I am trying to create a formula that I can insert into a 'start period' cell and drag to populate % changes (different for each period). What is the best function to utilize for this purpose? (See Below) <tbody> Using the "Starts" Table, calculate total fees for each project, fee amounts...