# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

so im trying to find time out, and i realized it only works if i dont change the current number made, and keep it at 0. other than that, it works well. but i need to including current amount of chairs, so as the day goes along, it gives more accurate time out
Solved by G. Y. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 27/07/2018 - 06:41
Hello
Excelchat Expert 27/07/2018 - 06:41
How are you?
User 27/07/2018 - 06:43
im well
Excelchat Expert 27/07/2018 - 06:43
Nice to hear that
User 27/07/2018 - 06:44
so here, you see ive set up an example
Excelchat Expert 27/07/2018 - 06:44
Ok.
User 27/07/2018 - 06:44
im trying to get it, as i change the current chair, the time out doesnt change
User 27/07/2018 - 06:45
as i increase the chairs done, it decreases the time out which is what i dont want
Excelchat Expert 27/07/2018 - 06:46
Total number of chairs are fixed?
Excelchat Expert 27/07/2018 - 06:46
i.e. 1000
User 27/07/2018 - 06:46
built
User 27/07/2018 - 06:46
the schedule is how many we need to build, and current chair would be how many completed
User 27/07/2018 - 06:46
and chairs left is how many we still need to build
Excelchat Expert 27/07/2018 - 06:47
so for example you have built 50 chairs
Excelchat Expert 27/07/2018 - 06:48
Yes so the chairs left to be built are 950
Excelchat Expert 27/07/2018 - 06:48
so the time required to built would reduce for 950
Excelchat Expert 27/07/2018 - 06:49
Ok. I understand what you are looking for. You need to keep the clock for 1000 chairs but you want to keep increasing current chairs
User 27/07/2018 - 06:49
yes
User 27/07/2018 - 06:50
so if we run at 100% (usually do) the time to get out is 11:16 AM in this scenario.
Excelchat Expert 27/07/2018 - 06:51
=E3*B1/60
Excelchat Expert 27/07/2018 - 06:51
instead of this make it on B2
Excelchat Expert 27/07/2018 - 06:51
B2*B1/60
Excelchat Expert 27/07/2018 - 06:53
So E2 and F2 remains same
User 27/07/2018 - 06:53
alright :) so if we did end up running at say....98%, would i just add a % to it to calculate the remaining time?
Excelchat Expert 27/07/2018 - 06:54
where are you accounting for running 100% or 50%?
User 27/07/2018 - 06:54
100%, but sometimes we run at 98% if we have bad parts
User 27/07/2018 - 06:55
so like....if we ran at 98% that day, all day. instead of 100%
Excelchat Expert 27/07/2018 - 06:55
so if you run at 100% time to complete is 19 minutes
Excelchat Expert 27/07/2018 - 06:55
right
Excelchat Expert 27/07/2018 - 06:56
and if you will run at 98% it will take 19.93 minutes, right?
Excelchat Expert 27/07/2018 - 06:57
I would suggest to add another variable of efficiency
User 27/07/2018 - 06:59
alright. thank you :)
Excelchat Expert 27/07/2018 - 06:59
Since I made it fix to 19
Excelchat Expert 27/07/2018 - 07:00
so when efficiency is 100% it is 19 minutes
Excelchat Expert 27/07/2018 - 07:00
try it now by changing the efficieny
User 27/07/2018 - 07:01
that works :) thank you
Excelchat Expert 27/07/2018 - 07:01
My pleasure.
Excelchat Expert 27/07/2018 - 07:01

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.