charged

I would really appreciate help with the following formula as I just can't get it to work. For each failure during a month I get charged 10 If I fail three months in a row I get charged and extra 50%, so 15 per failure. If I fail again in the next month I get an additional 50% on top, so it's...

Four people travelled to a place. their total expenses was Rs.2850. Divided equally would be Rs.712.50 A is charged 712.50 but paid Rs.1940 B is charged 712.50 but paid NIL C is charged 712.50 but paid 820 D is charged 712.50 but paid 90. Now A has to receive 1227.50 and C has to receive...

Good Morning, I have two spreadsheets: 1. Is a master file of 10,000 cutomers that contains all information such as name, ID, address, payment schedule, price charged, item brought 2. Is a file that has some information in, but has lots of missing data. I want to use file 1 to populate file 2...

Hello, I am trying to set up a simple time sheet tracker. How can I enter start and end times and then total the hours for each task. I tried in the below example but appreciate any help on this. Thanks Excel WorkbookABCDEFGH3Time Charged To4A/NDateAFR NumberShop OrderOtherStart TimeEnd...

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

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

Hi Hoping someone has the answer to the following. I have a production volume target figure for each month that is charged at a fixed rate. The same rate will be charged for all volume with 5% of the target. If the volume exceeds 5%, the exceeded amount will be charged at a different rate...

I need to create two new columns that are right adjacent to a specific column which I'll call "Charged Amount". The two new columns will have two unique headers created....one will be called "Discrepancy - Amount" while the other will be called "Discrepancy - Percentage". Once that's done I...

Using Power Pivot I have two tables I cleaned in Power Query One is all Data for current open work that we have, each open work item has a unique work item number I also have a table for time keeping that has anyone that has charged time to the open work item numbers. I created the...

Hi, I am trying to veryify my power bill and have raw meter readings showing kwh consumed in every half hour interval Is there a formula I can use to calculate the price I should be charged per half hour block? I am on time of use so i get charged as follows between 7am and 1pm mon - fri -...

Hi, When sending an invoice for work done, I use excel to set up an "installment nota" so that the customer has a complete overview of the amounts that are being paid for this month, in addition to the total accumulated charges since the project started. So the workbook usually ends up being...

Im doing someones accounts and i need to use the IF FORMULA to work out the values, so between if there wage is between £5000 and £45000 that week (lets say) i want there wages to be charged at 7.5% VAT and it works out the values for me. So when it goes over £45+k i want it to be charged at 20%...

I am trying to build a spreadsheet whereby I am able to figure out the total effective fees charged to a brokerage account based on the account balance. I know the fees charged for each $X in the account, but I can figure out how to do a "lookup" of sorts, or IF statements, to determine the...

Hi guys I have a various level pricing format as below, which should work similar to scaled commission / tax calculations. For example, 15000 units, should be charged as the first 5k (£0), the next 5k (£3 per unit) and the remaining 5k units charged at £2.50 per unit. I've done some research...