retention

Hi I'm trying to create the following formula for a sliding retention calculation based on an invoice amount as follows:- 1. If the current amount invoiced is less than $200,000 retention value is 10% 2. If the current amount invoiced is between $200,000 and $800,000 the retention value is...

Hi all, Please help me to calculate the retentaion rate of customer over months For example, - In January I have 4 new customer. - In February, 3 out of 4 continue to purchase my product > retention rate is 3/4 = 75%. - In July, 1 out of 4 purchase my product > retention rate is 1/4 = 25%...

Hi guys I need to write a formula that will automatically reduce the retention claim amount. So at the moment retention is kept at 10% each claim until 5% of the Main Contract Price is reached. For example: The Main contract price $2,231,435.00 5% of this is $111,571.75 (this is the...

Please take a look at the figure below. I have to sort new data (in this case retention time together with the corresponding area values) according to the retention time of the reference data (yellow). The retention time of the new data is not necessarily equal to the ret. time of reference...

Hi all, I'm trying to lookup every instance of a value (Vendor Name) and return the total sum of each of these rows value from another column (Retention Held). For example - When ABC Contractor is selected in cell R4, I want every instance of ABC Contractors on the Retention Register to be...

Hello. This question ought to be fun for the real "I can do anything with Excel" type of people. Here's the situation: I have a membership site and I'd like to figure out how to calculate attrition and retention rates from a table of sales data. Most other discussion about attrition and...