rate

Hi, I have a table as follows: Date Source Rate 06/04/1990 Property 18% 06/04/1990 Securities 10% 06/04/2016 Property 11% 06/04/2016 Securities 8% A client provides values of date and source and I need to return the appropriate rate where client date...

Hi, Have a table with Date, Category, Source and Rate, need value returned from Rate column, inputs are date, category type and source and each Date&Category&Source is unique (want to avoid using a helper column and VLOOKUP) If inputs are: Date: 30/06/2018 Source: Data1 Category: Number I...

Hello I'm a new user and wanting to know the formula that will allow me to choose the rate in Column C if Column A is chosen on another sheet? <colgroup><col span="3"></colgroup><tbody> Column A Column B Column C Rate A 10 5.85 Rate B 20 5.85 Rate C 30 8.77 Rate D 40 5.85 Rate E 50...

Hi guys, I have been strugling with this for Days. i am at a complete loss. basicaly i have the following <tbody> Candidate Client Date Day Start End Total Break Working Type Ref Ref2 A B 06/09/2018 Thu 19:30 07:30 12 1 11 RGN 152 45358335 B B 06/09/2018 Thu...

Hi, this may be a very basic question but hopefully that means there's an easy answer! I have a fixed budget (let's call it £10,000) and I have a set number of items that I have to sell. Different items are valued at different levels and I need to calculate a budget per item, using a consistent...

Hello! My name is Cristian and I'm from Ushuaia, Argentina, so, my apologies if I write it incorrectly. I have a problem using XIRR in Excel (and Openoffice Calc) When I use this cashflow feb-07-2014 -20000 mar-12-2014 73375.05 sep-10-2014 4400 oct-10-2014 4400 nov-10-2014 4400 dic-10-2014...

Here is an example of what my dataset looks like in excel: Column A Column B Column C Column D Row 2 A B C Row 3 1-1400 .25 .75 .50 Row 4 1400-1500 .50 .25 .30 Row 5 1501...

The Code Below Saves the File as "2019 Rate Volume - 2018-08-21.xlsx" I would like to have it saved like this "2019 Rate Volume - 2019-08-21.xlsx" How is the best way for me to go about this? Thank you in advance. 'Date Save Update Definitions MonthPath = Format(Month(Date), "00") & "...

I have a rule in column A to select a name from a dropdown list and I wish to add rules into column B that associates an hourly rate for each team member. I've therefore used IF statements for example IFA2="Alan",40,0).This works fine but if I want to add two tea members with the same rate I...

I found a way to add "Round()" to a range of cells (https://www.mrexcel.com/forum/excel-questions/618276-add-round-function-all-cells.html). Then I discovered an error in the underlying formulas. I've now decided I need to learn VBA well enough to not have to ask for assistance. But until then...

Hi, I have 80,000 records in sheet1, and 10,000 records in sheet2. What I want to do is that I have to find the same value in column A in sheet1 with column A in sheet2. If I find the same value in column A in sheet1, then copy value in column A and column B in sheet2, then paste it into column...

Hi there, I am wondering if someone can help me figure out how to format this formula. Let's say I open up a CD for 5 years (60 months). If I keep the money in there for at least 4 months without breaking it I will get a $1000 bonus and the APY is 3%. How do I calculate the effective annual...

Hello, New member to the website! I have attempted several searches for answers to the request and it looks like none of the threads have an answer to my question. I am looking for a formula to determine what the total cost of a subscription would be over a given period of years if the...

I have created a budget file with multiple sheets, each sheet has rows by category and columns for each month. The expenses I wish to track can be in one of the following currencies: $, €, ₪, I would like to enter the cost is the currency I have paid at, let's say € so could always know the...

Hi Guys - I can't figure this out for the life of me. I have a mixed chart with actual revenue numbers, and a YoY growth rate in the form of a line chart graphed on the secondary axis. For year 1, the change rate is 'n/a' since I cant compare a year that doesn't exist yet. By having that...

In a nutshell, I have an Excel workbook that updates Exchange Rates, the workbook is driven by dates (fortnightly basis). A historical worksheet shows the rates each fortnight – the date is the driver but the issue I am having is that when a rate has not changed I need the formula to search...

I'm trying to reverse engineer hours based on a team with various %s totaling 100%. In the end, hours X each individuals known Rate will all sum to be $175,000. I have a program that does this but I'm trying to replicate in excel. First table below is completed in the program and every time I...

Hi!! Need some help. I have an amortization table for a loan. The rate can be variable with the option for lump sum payments. When a lump sum payment is made, I need the payments to stay the same with the end result being the loan is just paid off faster. Here is my calculation...

So I've been tackling a problem for a few hours, and I just can't figure out how to approach it. I know what I want to do, but not how to do it. I'm making an automated character sheet, and for the most part it's simple. The user selects various values from dropdowns on the first tab, and...