fee

  1. D

    Combining SUMPRODUCT & COUNTIF with multiple criteria in sigle column

    I have a table which has a column containing job status (e.g. live, dead, invoiced etc) and a separate column with a job fee and a third column with a Sub Fee. I have used:- =SUMPRODUCT(SUMIF(TabJobs[Current Job...
  2. S

    Getting messy data into one line

    A big part of my job is getting spreadsheet data from different clients and putting the information into our database. Most of our 200+ companies send reasonable spreadsheets I can manipulate pretty fast, but one insists on sending what I think is a scan of their paychecks, converted into...
  3. F

    Formula works on paper, but not in spreadsheet. Error = a specific expression is added to desired result.

    Hello, l am using LibreOffice Calc but l'm hoping it won't affect matters. KEY TO EXPRESSIONS: $AG$3 = PayPal fee percentage $AG$4 = PayPal fixed fee per transaction (e.g. £0.30 per transaction) $AG$6 = eBay Fee Cap $AG$7 = Alternative Payment Gateway fee percentage $AG$8 = Alternative...
  4. 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...
  5. Y

    reverse-percentage-calculation-on-percentage-fee

    I have a calculation Problem In My Application In which I need to Calculate Reverse Amount From Grand Total Amount. I Need Logic/Formula for It Need you guys Help. <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch...
  6. I

    Combine this if formula

    Hello board members! I have this formula: =IF(AND(E18="Yes",OR(A8="ABCD",A8="EFGH")),"-1.48% Fee","") It need another condition: =<date(2019,5,1)........"-1.48% fee","") IF(D16<<date(2019,5,1)........"-1.48% fee","")="" <="" date(2019,5,1)........"-1.48%="">DATE(2019,5,1)........"-1.48%...
  7. M

    Better way to use Multipage Textboxes

    I'm using a Multipage (13 pages) on a UserForm and on each page I have 8 text boxes. These text boxes get calculated and the resulting value is entered into a cell on the worksheet. I have one set of controls (Enter, Calculate, and Clear) on the UserForm section. The 13 pages represent...
  8. S

    Find matching value in large table and return associated data

    Hello, I have a large spread sheet that lists multiple currencyvalues. For each value there is anassociated daily fee, weekly fee, and monthly fee. For example: <tbody> Value Daily Rate Weekly Rate Monthly Rate Value Daily Rate Weekly Rate Monthly Rate Value Daily Rate...
  9. S

    Search table for matching value and return another value

    Hello, I have a large spread sheet that lists multiplevalues. For each value there is anassociated daily fee, weekly fee, and monthly fee. For example: In a separate location I want to be able to populate the dailyfee, weekly fee, and monthly fee for the specific value that I enter into...
  10. M

    Loan repayment and receipt allocation to fees in order

    Hi Is it possible for me to handle receipt allocations to a loan in excel or access? <colgroup><col><col><col><col><col><col><col><col><col><col span="3"><col><col span="2"><col><col></colgroup><tbody> Borrower Name Agreement Number Transaction Reference User Agreement Date Repayment Method...
  11. B

    VBA - Show data based on drop down date

    Hi there, I'm hoping some excel genius can help me with this query I have, I tried to ask using formula but I don't think it can be done, could someone assist with the VBA code please? ; On the attached sheet I have 2 tabs, 'Fee Summary' that houses the info & 'Fee Changes' where I want the...
  12. B

    Show data from previous sheet based on drop down value

    Hi there, I'm hoping some excel genius can help me with this query I have; On the attached sheet I have 2 tabs, 'Fee Summary' that houses the info & 'Fee Changes' where I want the data to show. The same 8 columns are replicated for each month on tab Fee Summary. I would like to show that data...
  13. C

    Lookup

    I am trying to look up a column based off a town and a service for example I want to lookup Victoria, C Basic, Start so the answer would be 19, or Munjor, D EAGLE DIGITAL, Reconnect so the result, any Ideas <colgroup><col><col><col><col span="10"><col><col><col><col><col...
  14. G

    Tiered Fee

    Hi, i would like like to calculate a composite fee rate based on the following sample tiers: 1st $225m charged at 0.50% Up to $450m charged at 0.45% Above $$450m charged at 0.40% So the fee on $1bn would be 0.50% on the first $225m, 0.45% on the next $225m and 0.40% on the remaining $550m. I...
  15. C

    if calc doesn't meet min, auto insert flat fee

    Hello and thanks in advance for any help. I'm trying to create a purchase sheet that includes a set up fee. The fee is either a percentage of the total or a flat fee of $130 whichever is greater. I have the formula calculating the percentage based on the subtotal [=15% * C1] but I want to...
  16. B

    Formula based on multiple criteria?

    I need help with a formula to return fee amounts based on the account number and start date. In my example I need the fees and market values for all three months for each account. Please help! <tbody> ACCOUNT # 11/1/2018 FEE 11/1/2018 MARKET VALUE 12/1/2018 FEE 12/1/2018 MARKET VALUE...
  17. D

    Calculated Average by Fee Level

    Hello - I'm trying to calcuate a measure where I can see the average number of hours by fee level based on the 'individual'. As an example based on the data below, the average for Person A would be 4 within the 20K fee level. <colgroup><col><col><col span="5"></colgroup><tbody> Fee...
  18. D

    Calculated Average by Fee Level

    Hello - I'm trying to calculate a measure where I can see the average number of hours by fee level based on the 'individual'. As an example based on the data below, the average for Person A would be 4 within the 20K fee level. <colgroup><col><col><col span="5"></colgroup><tbody> Fee...
  19. C

    Grand total column Power BI

    I have two columns in my Power BI table, one for Project Fee this is the total Fee my company will be charging for a project it was already loaded to the table when I brought it in. Then I created a column in Query Editor that added together Project Fee and 2 other columns that I named Project...
  20. C

    Project Fee issue

    Good afternoon, I am working in Power BI Desktop and I am mostly comfortable in Power Query but I am not opposed to solving this through DAX either. I am importing data from my companies financial software and it is causing a bit of an issue when I want to calculate the total fee of all...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top