effective

I would like to know if there is a function in excel to compute the nominal interest rate if the effective rate is negative If the effective rate is positive the formula =Nominal works perfectly I can however compute this using a mathematical/accounting formula Book1AB1Effective Int...

what would be the most effective way i could filter every column for the same criteria? so far i can think of the below sub i made, but it doesnt seem to be that efficient if multiple columns contain the criteria. If you could help me to understand another method i would greatly appreciate the...

Hi guys, I want to replace below characters in first raw in range("I3:P52") into those in second raw. Could you pls advise if there is an fast and effective way to do so? As you can see the range is 400 cells altogether. ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ...

Re: Goal seek function in excel Guys, I am having some challenges with the MS Excel GOAL SEEK function. It worked alright for the first few times that I used it to work out the EFFECTIVE INTEREST RATE for the issuance of bonds. However, it is now coming back with absurd results...

Hi expertise, I have 5 different values to be used in multiple cells. if cells contain all the value then, Unsatisfactory to be shown. if cells contains all value except unsatisfactory then Inconsistent to be shown. If cells contains all value except Unsatisfactory and Inconsistent then...

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

Hi all, Need some help with SLA generation as I've expanded all my resources to find the answers and this is why this is my first post. I'll try to be as thorough as possible. The SLA computation in my customer's account has a 3 days SLA to complete tickets. Example: - Supported hours - 7am...

I'm having issue with a macro that I never used to have issues with. The code goes through the Header/Footer of each worksheet within the workbook and updates it with three lines in the Left Header: Company Name Program Effective Date It also adds in a logo that we use in the right footer and...

Hello, I need help writing an "IF" statement. Cell C2 contains one of five possible responses: Exceptional, Highly Effective, Solid Performance, Needs Improvement, Not Effective In cell C3, I would like to assign a numerical answer based on C2. For example: If C2 equals Exceptional I would...

Good morning, The way our planning system is set up, it creates a brand new record for an employee if they move departments. The first record will have an effective end date on the date of the transfer and the second record will have an effective start date on the same day. Normally, if they do...

Hello there! I'm trying to make a spreadsheet that would automatically populate a cancellation effective date. If a product is cancelled on the 10th day of the month or less, than the cancellation effective date should be the last day of the current month. If the cancellation is greater than the...

Hi all, Another quick question: I currently have a spreadsheet that has a year column and an effective date column which has the month and day. I'm looking for a macro that will merge the two columns into one with the format (month-day-year). Any advice is greatly appreciated! Right now, the...

I have a sheet where I want to flag 60, 90 and 120 days reviews based on an effective date and Calendar dates, but the formula I have is not working. Here is what I have: <tbody> A B C D E F 1 Customer Effective Date 11/1/2017 12/1/2017 1/1/2018 2 B. Smith 9/1/2017 </tbody> Here is...

Hi - I have a tab within excel that is an assignment list which details people and effective dates\rates. There are multiple people and one person may have more than one line if their rate changes mid year. I then have a tab containing timesheet data for various people and I want to be able to...

Can someone help me with my formula, or suggest an easier way? I'm trying to get all of the "Period End" dates to fall within a specific "Effective Date" using a formula (=IF(LEFT(H5,1)>=7,"08/17/2016","01/17/2017"). For Period End dates between July and December, the Effective Date should be...

Gonna try and keep this real simple to understand. I'm trying to calculate residual income from insurance policies sold a year ago. The data is as follows: A:A = Date policies went effective B:B= Status of policy (it must be active to pay a residual) C:C= Residual amount to be paid. The...