# Calculate number required depending on previous months' results

1. ## Calculate number required depending on previous months' results

Hi
Hope someone can help?

I need to write a formula that will solve the following problem, but so far I'm not having much luck.

I work in a call centre and my job is to assess the staff's calls.

Each month they have 7 calls listened to. If they score above 96% they stay on 7 calls the next month. If the score <96% they need 12. If those 12 score below 96% they would need 17, but if they reach 96% they go back to 7 the following month. 17 is the maximum, so when on 17, they will either stay at 17 (if they score <96%) or drop to 12 and then to 7 etc.

Hope this makes sense? I want this calculation (I.e 'how many calls does John need listening to in September?) to be automated, depending on his scores for the previous months!

I might be wanting too much, but if anyone can suggest a way forward, I'd very much appreciate it.

Hope my explanation of the scenario is clear!

2. ## Re: Calculate number required depending on previous months' results

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

3. ## Re: Calculate number required depending on previous months' results

Hi and welcome to the forum.

Be sure that best way to describe your problem is to upload a sample workbook.

Be sure that all sensitive data removed, showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that.

To attach a small sample workbook.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

4. ## Re: Calculate number required depending on previous months' results

I've created a 'mock up' of what a three month 'summary' would look like, but it's hard to describe (hopefully it makes a little more sense).

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1