rates

Hi I actually need help on both of these. I just need to return blank if nothing is found. Right now it returns 0 if nothing is found and is kind of annoying thanks =' Rates Table'!A68 =IFERROR(VLOOKUP($A$6:$A$208,' Rates Table'!$A$1:$D$506,4,0),"")

I'm not sure if this can be done or not. I have dug through the threads and google looking for code. I have multiple rate sheets that are named by client. On the sheets are the equipment we are going to use along with the rates we are going to charge. I don't want to just copy and paste the...

Hello all, Bank of Canada recently redesigned its website from which I used to pull daily exchange rates and now refreshing my file doesn't work any more. I now need to first specify the currencies I need along with my target date on the new site and then it displays the target rates. If I...

hi i have three different rates for one product a= 10rs for 5nos and for 10nos rs30 and 15no rs40 i want a formaula when i type 5 in one cloum it should automatically multiply with rs10 and rate shd reflect in colum.. like wise if customer select 10 and 15 it shd multiply with 30 and 40 can...

Hi, When I use this formula the window pops up. I think I a missing something where its looking for the other sheet called Rates Table. I even tried to use this 'Rates Table' but still same issue. Any help thanks =IFERROR(VLOOKUP($A$6:$A$200,Rates Table!$A$1:$D$500,4,0),"")

Hi! This might be more of a math question but here goes: I have two different contract rates, $52.38 and $52.50. Each rate corresponds to a certain amount of revenue, lets say $30310 and $1253 respectively. What would be the weighted average of those two rates? I got 52.39 using sum...

I have a excel data containing than 10000 rows in which world's continents name are listed in column "A", countries name in column "B", cities name in column "C" and growth rates in Column "D". Now issue is whenever I try to count the number of cities that come under "India", under "Asia...

I created a land development waterfall model for GP/LP flows using certain hurdle rates and promotes. It works fine in the base case. In the distressed case, meaning slower land sales, the IRR hurdle rates don't work because there is a need for cash later but it wasn't reserved for and I'm at...

Hi, I have a workbook with 4 worksheets, one of which is called Crypto Rates. Its very rare i access this worksheet as it just pulls in data from a websource. There are other cells throughout the workbook that reference the data collected. I have the following makro that auto updates the data...

Hello - I'm looking to find the lowest carrier based on a certain criteria. Hoping someone can help. Cell C56 gives me my rating bands 1-22 If C56 is NOT 7 or 15 I need to find the lowest silver rate among Aetna, BCBS or United F55:O55 is the row that list all my carriers F56:O59 are my rates...

Hello, I have, with help of this forum, gotten my workbook to close without asking to save. I have done that with this code; Private Sub Workbook_BeforeClose(Cancel As Boolean) Saved = True End Sub Now, the problem is, that this code disables anybody from saving any changes (and that is...

Hello friends, I am new here but i need your help for a excel sheet that i am making. I have the City and the Weight in one sheet. In the other sheet, theres the cities, all weights and the costs. In the first sheet, we can select the City and the weight. I want to show in that same sheet the...

I'm trying to look up rates based off of weight and miles. <tbody> Weight Miles 500 1000 1500 2000 250 4.5 6.5 8.5 10.5 500 7.5 9.5 11.5 13.5 750 12.5 14.5 16.5 18.5 </tbody> I have a cell where I type in the weight and another cell where I type in the miles. I want the 3rd...

Hello I have some experience in excel but not much. My boss at works wants me to make an excel worksheet that we can send out to our clients to determine the amount they will owe us on any job that comes up. Pending on the job amount the client their amount will vary. For example if they were to...

<tbody> A B C D E 1 <tbody> COMPUTER NAME </tbody> <tbody> TIME STARTED </tbody> <tbody> TIME FINISHED </tbody> Duration Amount 2 A <tbody> 07:45:00 AM </tbody> <tbody> 10:00:00 AM </tbody> 3 B 4 C </tbody> I need to display in column D the...

Hi there, First time poster but long time reader! I am looking for a formula for a budget that deals with getting a total from an equation if a cell doesn't have any data. I would like to try and figure out the following: Cell1 - No of People Cell2 - $Rate Cell3 - Weeks Cell4 - $Total...

Trying to write a formula that will allow lease rate escalation to be variable between two rates. Example inputs: Lease Start Rate = $20/sq ft/yr Escalation years 2-3 = 10% Escalation years 4-end of lease = 4% Square feet of lease = 15,000 Lease starts year x Lease ends year y Any thoughts or...

I charge one rate for day work and one for night shifts. My spreadsheet is set to figure the total number of hours worked and I know how to multiply by dollars to get answer #1, but is it possible to use a formula to multiply times a different rate for a night shift? For example I use...

Hello I have a spreadsheet with a long list of prices in GBP that need to be converted to USD, HKD and RMB, they need to be marked up for retail pricing, pull live currency exchange rates and then rounded. I have done this manually but need an embedded solution pulling live exchange rates that...

Hi, I have to pull certain rates data for specific customized periods . And this is taking hectic time. Please help. Please revert for any clarifications.