Brain Freeze - What is the formula and whats the best way you would do it

Eisasuarez

Well-known Member
Joined
Mar 23, 2012
Messages
653
Hello ALL

I am trying to give my manager a true reflection of the percentage resolved vs the percentage incoming to show if we are being productive or not . Whats the best way you would do it and what formula would you use based on the scenario below.

Yesterdays Work Total: 100
Resolved Yesterday

Todays Work Total

Now based on the above there are 10 more pieces of work than yesterday

What percentage of work has been resolved and whats the percentage of work that has come in and how many.

This can then be used to compare if the percentage resolved is better than the percentage incoming however my mind has gone blank to how to get this result

Can someone be kind enough to help me

Thank You
 
Hi

Thats what i got and i was wondering if that was the correct formula to get the incoming volume?

in regards to incoming percentage, what formula can be used to get thatfigure and what formula do i need to get percentage resolved?
 
Upvote 0

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Forum statistics

Threads
1,215,941
Messages
6,127,794
Members
449,408
Latest member
Bharathi V

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top