How to calculate number of task required at a certain percentage to achieve target goal

Hi Good day to everyone.
I need help in getting a formula of this problem. How can we solve for no of task required completed at a certain timeframe for the employees to pass at 100% to goal(lower is better). Im familiar but im not really good at algebra so now Im having a hard time solving this problem

Variables are
1.) No of tasks
2.) % to goal of the time employee took to complete the total no of task
3.) Goal at 100%
4.) No of tasks needed at at a certain timeframe in percentage(ex 90% of the time required) for the employee to finish

For example.
Employee 1 has 139% to goal at 20 tasks and his target goal is 100%(Lower the better). How many tasks does he needs to complete at 90% timeframe to reach 100%. I cant seem to find a solution online.

Its part of the problem which makes it more difficult since I only got the sum of hours it took over goal time total no of tasks result which is 139%.

Also see https://www.mrexcel.com/board/thread...t-goal.1158410

I'm confused about your terminology. What you have in the sample file is:

	A	B	C	D
1	Employee Name	Tasks Completed	Handling time based on goals	Tasks Required at 90% of Goal to Pass at 100%
2	Edgar Del M	25	130%
3	Enrico Torres	10	95%	0

I think C2 says that the 25 tasks in B2 are 130% of Edgar's goal. Right?

So Edgar's goal was =B2/C2, which is about 19 (19.2307692307692).

I don't understand what tasks "required at 90%" of goal "to pass at 100%" means.

The formula above calculates the number of tasks that Edgar completes to meet 100% of goal.

The formula to calculate 90% of goal is: =90%*B2/C2, which is about 17 (17.3076923076923).

Does either of those formulas give you the answer that you are looking for?

If you want integer results, wrap ROUND(...,0) around each formula, to wit:

100% of goal: =ROUND(B2/C2, 0)

90% of goal: =ROUND(90%*B2/C2, 0)