rates

Hi, I am looking for a formula that will calculate my monthly payments based on a daily rate for each month. I have manually entered the costs below to show what I am looking to return. <colgroup><col><col><col><col><col><col span="6"></colgroup><tbody>...

I am sure my title is not correct on what I need to do. OK, I have a spreadsheet (work book) that has 2 sheets in it. Points has city and miles. <tbody> <tbody> Points Miles MEMPHIS TN 13 GERMANTOWN TN 18 BARTLETT TN 22 CORDOVA TN 24 COLLIERVILLE TN 27 MILLINGTON TN 29 EADS TN...

I am trying to write a formula that will apply different rates if a certain cell is a Y or a N -----the 2 rates to apply are: *Focus Funds = 55% of AMF OR **Architecture Funds = ("A std") + ( "A mgmt fee" x 20%)

Hi All, I need to create a register to track the cost of concrete. There is a range of concrete mixes with varying costs. I want to have a drop down list so you can select the Mix which will then automatically return the cost per m3 I have set up a DATA ENTRY TAB which lists the ranges of...

Hi, I have a web data query about exchange rates. But somehow, it can't refresh the data sometimes properly. (I think it is because of the page's bad design. Query can't find the target table every time.) I have set "Refresh on workbook open" only. What I need is to keep the previous rates if...

Hi all, I am trying to calculate shift rates depending on times. I have the following shift rates, but I cannot seem to get the results returned I'm looking for due to the times of some shifts going past midnight. As an example a shift might be 15:30 - 01:30. <colgroup><col width="145"...

Hi All, In column A I have a currency symbol, examples as below. GBP USD CHF In column B I have an amount within the currency outlined in column A. 1000 2000 3000 I have a separate tab called exchange rates for concerting currency into EUR so for example within this tab there are two...

Hi, so I have a spreadsheet that we enter employee schedule/bid changes into if they take a new bid. Each bid is assigned a number and from there contains different information across the row pertaining to that bid (days off, hourly rate, Type of job and some other points of information) The...

Hi All, hoping someone can help me out again? I have a small table of rates that i can use INDEX or SUMPRODUCT to find a specific rate based on the role and subcontractor. I have another column of hours that i would like to use this rate on. Next to the hours column is another column that...

Hi there I cannot seem to get the mortgage/loan bank statement replicated in excel. Can someone please help? I think it has something to do with when they change rates based on the number of day. I think they use exact days. You can see at the top of the statement the rates and the date...

Hello, I am making rate calculator for clients to type in their ages and the ages of their dependents to know their insurance premium. Blue Cross has the rule that subscribers only pay for the first three dependents under the age of 21. (the largest 3). These ages and rates are only a sample...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hi, Good Afternoon! I was able to include the Indirect Function by the help of Spreadsheet but now I need to get a function the will then choose 2 options on each sheet. Scenario: Sheet 1 - Export Sheet ** 2 options Document Rates or Non-Document Rates Noted: Rates are on different cell...

Hi, I am stuck and need some help please. In my excel workbook I have two worksheets namely "Payroll Register" & "TAX Rates & Rebates" I am trying to reflect the employee's TAX Rebate based on his/her age as per the following table; The "Payroll Register" worksheet contains the employee's...

Hi all, I have a timesheet which we do our daily hrs tracking. we have diffrent pay rates and there for i want my time tracking to show me diffrent sections this is the formula at the present moment but it calculates all: =SUMIF(TimeLog!$A$20:$A$2146,"=YES",TimeLog!$G$20:$G$2147) i now need...

Hi I am trying to make up a Time sheet for work to calculate my pay. I have most of it but I cannot work out how to apply penalty rates. Have got the overtime rates but I get paid a penalty for doing afternoon shifts and night shift Each having a different rate Can't work out the correct formula...

Probably more of an algebraic question than it is an Excel question, but if I have 8 quarters' worth of year-over-year growth rates, is there a way to back into quarterly growth rates? For example: Quarter ------- YoY Growth Rate Q1'00 ------- 9% Q2'00 ------- 11% Q3'00 ------- 13% Q4'00...

Essentially trying to figure out a formula or what function to use to figure how much what % will come out of a base amount, where the % rates are referenced from a separate table displaying value ranges and what % rates apply to them. https://imgur.com/gallery/tYKuK Its a pretty basic...

I have a below data <tbody> Month 1,056,244.83 Actual Rate Completed Tenor Rate Actual Rate Profit Completed Tenor Profit Rate Differential Differential Rate New Profit May-2017 13 5.40% 4.29% 2,031.46 1,613.88 1.08502410% 4.31% 1,623.28...

I am working on consolidating several different employee groups. They are separated by different benefit rates. I have 25 different groups, each with 9 different rates. I am looking to consolidate the 25 groups if possible by comparing similarites in the rates. Is there a formula that can help...