fee

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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