rate

Hi, I am trying to use Excel to calculate income tax. The tax system has a number of rates applied to each band as follows Lower Limit (H22) Upper Limited (I22) Rate (J22) Tax Free Allowance (G23) £0...

Hi I have an excel report and columns with values, I need to create a input button that when I insert a new rate and click calculate it changes the values in the relevant cells to the new values. Example 10 and when I put in the exchange rate 1.5 and click calculate the values in the columns...

Hi, I have been racking my brains for the past 3 hours trying to make a formula work for me. I have a table in which contains a Date From, a Date To, a persons name and then 2 columns for charge out rate (basic time and overtime). In my master sheet I want to be able to book a person at a...

Hello, I am trying to create a spreadsheet that will break down my average electricity costs by day to help me better estimate accruals for invoices I haven't yet received. My columns are: Invoice Payment - (1/1/2019 - 2/4/2019, for instance) Average Rate/Day (By Invoice) - (The invoice...

Hello guys, first post here on MrExcel. I'm a proficient Excel user with several years of experience but completely new to VBA and I believe my current problem can only be solved with VBA. I looked the web for hours, but every question was case specific and I couldn't adjust their solutions to...

To preface I am trying to decide if formulas, a pivot table, or VB code is the way to tackle my issue. My head is spinning. I am attempting to calculate earnings based on multiple work based scenarios. I have created drop down validations across multiple columns. Each drop down affects a per...

Hi I want to create a work sheet to calculate income tax a follows TAX RATE SLAB TAX YEAR 0% 0-300,000 2019 5% 300001-50000 20% 500001-1000000 30% 1000000- income 354000 Besides using if conditions is there...

Hello, I have a table with 40 rows and depending on input the values change from positive to negative. So with an inflation rate of 2.5% then row 23 will be the first row in negative numbers, if I change inflation rate to 1% then row 28 will be the first row in negative. How do I conditionally...

Hi I can't find any information on how to do this other than through some sort of goal-seek. Ideally I'd like a formula-based solution, if one exists. Basically I need to 'reverse-engineer' the NPV calculation to find the rate. I've illustrated my problem in the image below (I'm trying to find...

I have been offered 2 payment methods as I was buying some tools for a company I work for. I need your help to assess the best method. Here it goes, Total cost is $100 and I don't want to pay it all in advance. First offer is they increase the total cost by 30% (they call it "financing cost" ...

Hi, I currently use the RATE() function in Excel to calculates rates before entering details in SAP. However this only works if the payments are the same every month, which is not always the case. Here are two common examples I would like to be able to calculate: Variables: 60 months £50,000 pv...

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

Hello, I'm trying to pull what a service rate would be based on a position and a specific rate card. For instance I have a list of titles and rates, and a list of titles and rates under different rate cards. I am looking to pull back the rate for a title under a specific rate card. Sheet 1...

Hi All, i need to create an invoice for a new client although its proving to be a little difficult as he wants me to calculate things by the minute. So i have an hourly rate of $50 ex tax (tax is 10%) im looking to just input my hours & minutes and the formula automatically calculates the tax...

Good morning. I need help with the following, thank you. There are 2 columns: ID and rate. Some IDs are repeated, sometimes 3 times, 5 times, 9 times etc. I need to pick the highest rate for each ID and there are over 20,000 IDs. I tried DMAX but didn't seem to work. Thank you for your help...

Hi there, I have copied the following formula from a workbook produced by someone else: =INDEX('£m2 Site RUN RATE '!$C$79:$C$99,CEILING((ROW()-1)/(MATCH("zzz",'£m2 Site RUN RATE '!$79:$79)-1),1)+1) The objective of it is to re-produce data in one worksheet into a new 'columnar' based...

I have a drop down box of three options, each one of which has a different % that needs to be added to a rate when selected, how would i go about attaching this % amount to the rate via a formula when selected?

Hi Team, Below is the table <colgroup><col style="mso-width-source:userset;mso-width-alt:3693; width:76pt" width="101" span="3"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt"...

Hi All, Happy Holidays Need some help on a project. Trying to calculate this for someone, if they work weekly # of hours at a rate of $13, but now we change the rate for $15, now this guy wants to keep paying the same weekly amount dollars from the $13 rate, when they make the $15 amount. So he...

Hi, I have been working on a debt consolidation calculator. Basically I want to list a set of debts and have excel calculate when each debt is being paid off and create a graph over time. The part I am having trouble with is as each debt is being paid off, the contribution of that debt now...