Hi there,
I need to make a quick formula to calculate a service level.
The target is 95%.
As an example let’s say 95 calls were offered and 70 were answered. What is the service level and what forumula would you use to calculate it.
Another example would be 100 calls were offered and 95 were answered which would be a service level of 95% just need help making the formula to calculate!
Thanks in advance for your help.
Ryan
The formula is this:
=(70/95)*100
Answered calls divided by calls offered multiplied by 100, which gives you the percentage of calls answered.
You can do it using cell references thus:
=(A1/B1)*100
where A1 is answered calls and B1 is calls offered.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Do you just need a formula to calculate the percentage?
If yes, then put number of calls offered in say cell A1 and calls answered in say B1 and in C1 use this formula-
=B1/A1
Now right click cell C1 >> format cells > percentage >> OK
Hope that helps!
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
=A1/B1
B1=95 (Calls offered)
A1=70 (Calls answered)
Format cell as %
Thanks, that done the job!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks