rates

  1. M

    Excel Check Employee Rates

    Hello! I have a spreadsheet I use for creating invoices for our clients. We have formulas that calculate the raw rate (showing employees rate before any profit multipliers are applied) for each line. This is part of our checks and balances process for our client, as they look at the rates for...
  2. L

    Rounding time up to the nearest quarter hour

    I am tracking time for short projects and having trouble with rounding to the nearest quarter hour. I am not sure why, but sometimes projects that are exactly 15 minutes round up to the next quarter hour and sometimes it remains at 15. I would like projects of 15 minutes or less to bill at 15...
  3. H

    Getting Specific Rates for Certain Cell Conditions (Logistics)

    Hello All, Firstly, I'm glad to be a member on this community and excited to have my first post. Here's my query: So I wanted column F to auto populate the CWT rate for our shipments. This column F would at least show how much cwt the carrier "column E" would charge us for that weight...
  4. Y

    Finding a value based on an effective date with multiple criteria

    I have a sheet with pay rates. There are about 80 different pay rates that differ for age, gender and competition type. Rather than have a sheet with a rate for every day of the year for the past 12 years I'm wondering if there is a way to do this with effective dates. So when I'm looking up a...
  5. reneev

    Conditional Formatting: everything but "X", "Y", or "Z"

    We are trying to capture errors in rates. Rates can either be 0, 36.12 or 40. How do I conditional format a cell if it's anything other than one of those numbers? And can it be expanded for additional numbers if I have more than three rates
  6. B

    range of rates different group intervals

    Hello I am trying figure out the best way to figure out how to get the total # of rates per title in a given range. the rate ranges are uneven intervals. ex master sheet a list of titles column A a list of different rates column B sheet 2 has the list of titles no dupes and the rate ranges...
  7. L

    Complex sum required based on VLOOKUP. - not working!

    I am creating a pricing template for services, a section of which is based on an hourly rate. The rates, are by level of seniority which need to be added together then multiple by the number of hours. I would like the option of only selecting the level of seniority and adding the hours, then...
  8. P

    changing balance compounded interest calculator with changing rates

    How would one go about designing an excel sheet that calculates interest like a bank's savings account, meaning balances that change from day to day and interest rates that change during the year? Preferably, the interest rates would come from a table.
  9. R

    Backing into Hours Needed based on Total Cost of Project

    Hello! Is there way to calculate the hours needed at two separate rates that add up to the total cost of a project? For instance, the estimate is 40,000, and the hourly rates are 120/hr for one position and 150/hr for another position. How many hours of each rate would I need to get to 40,000...
  10. R

    Index Match Formula?

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

    tiered lookup

    folks, i am trying to match and compare two data sets to ensure we are charging the correct amount. One contains the rates charged for medical procedures (Rates) and the associated service fee charged for ancillary items, and the other contains patient level data (Patients) including fees and...
  12. D

    Exchange Rates

    What is the easiest way to calculate exchange rates in Excel? Is there a formula wherein the currency code can be entered and it returns the exchange rate into currency #2 for a given day? Seems like there should be a formula for that, but haven't found one. thanks!
  13. V

    VBA/Data Scraping - Pulling (Today's) Bond Rates Into Excel

    Hello, I am trying to pull current market data (bond rates) into excel from the below link: https://rates.chathamfinancial.com/us-market/rates In short, I am trying to pull the rates for each respective term in the 'Current' column as per the highlighted below. I have been able to do this...
  14. P

    compare 2 tables with similar names

    hello, i want to compare a set of roles and rates with another set of role and rates however the rates might have different names like Account Director and Account Director (12) or account manager and acc manager as examples. is there a way to compare the data with 90% similar roles and then the...
  15. M

    vlookup rates without table , need formula

    GOMA 480000 250000 KASUMBALESA 480000 250000 KITWE 420000 200000 LUBUMBASHI 480000 250000 LUSAKA 420000 200000 NDOLA 420000 200000 These is the table of rates I need one formula two pick those rates on b1 and c1 where a1 is location I dont need this...
  16. A

    Recording Data when using =rand()

    Hi all!, Quick question: So im trying to create a financial model that uses the rand() and randbetween() functions to put in randomised growth rates for certain parameters for a company. Ive successfully set up the functions and output but i want to quick record the output each time I press F9...
  17. D

    Calculate variance outside band of two rates of pay

    Hi Slightly weird question and I'm hoping Excel is not going to let me down. I've prepared an IF statement to show if a hourly rate of pay falls with a band of two pay rates and to return "YES" if it does and "NO" if it doesn't - =IF(AND(R3>=T3,R3<=U3),"No","Yes") If I get back "NO" I then...
  18. H

    VAB Code Update Labor Rates

    Hello All, New to VBA and just bought a book to learn. Trying to update labor rates in column B "not null" when column A = FY-19. I have about 30 excel files and each one tracks the cost of the 30 individual projects. There are about 450 rows that have the individual manufacturing process's...
  19. srizki

    =if(sumproduct( or if(countifs(

    I have Cost centers in column G and interest in column Y, Cost centers are repeated and so interest rates accordingly, only one interest rate should be for one cost center, so if there are more than one rates there is an error, so for example <tbody> 411044924 5.280613 411044924 5.280613...
  20. K

    Can't change number format to drop the $ sign

    This one has me stumped! Every day I have an XLSX file that I download from our payroll software and then I copy the data into an Excel template that feeds the information into different tabs. When the data is downloaded, the rates all have $ signs (ex. $10.50). In the template I am pasting...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top