Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula which will calculate percent complete (column G) against total number (column J) which will give the remaining units
Solved by V. Y. in 7 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
12/04/2018 - 11:15
2017
Excelchat Expert
12/04/2018 - 11:15
hi how are you?
User
12/04/2018 - 11:15
2010
User
12/04/2018 - 11:15
good, have you been able to identify the formula i need?
Excelchat Expert
12/04/2018 - 11:15
is it possible to request for a sample data we could work with?
User
12/04/2018 - 11:16
just pasted into the spread sheet
Excelchat Expert
12/04/2018 - 11:16
Okay, do we need to create a new column for this?
User
12/04/2018 - 11:17
I need a formula that will give me the remaining units. yes.
Excelchat Expert
12/04/2018 - 11:17
okay
Excelchat Expert
12/04/2018 - 11:17
rounded up to the whole number?
User
12/04/2018 - 11:18
yes that is fine
Excelchat Expert
12/04/2018 - 11:18
please see sample row in column K
Excelchat Expert
12/04/2018 - 11:18
no need to round off?
User
12/04/2018 - 11:18
No need to round off
User
12/04/2018 - 11:18
that is exactly what I was looking for
Excelchat Expert
12/04/2018 - 11:18
okay. are you able to see cell K2?
Excelchat Expert
12/04/2018 - 11:19
glad to know. feel free to copy the formula and paste it to the succeeding rows
User
12/04/2018 - 11:19
yes i see it
User
12/04/2018 - 11:19
I am looking at the formula
Excelchat Expert
12/04/2018 - 11:19
is it okay if we mark this problem as ANSWERED?
User
12/04/2018 - 11:19
of course
Excelchat Expert
12/04/2018 - 11:19
great. thanks!
Excelchat Expert
12/04/2018 - 11:20
i can see that you are able to catch up pretty quickly. :)
User
12/04/2018 - 11:20
Thanks
Excelchat Expert
12/04/2018 - 11:20
i'm happy it comes across as a clear solution to you
User
12/04/2018 - 11:20
still a lot to learn
Excelchat Expert
12/04/2018 - 11:20
of course, even I have a lot to learn still :)
Excelchat Expert
12/04/2018 - 11:21
anyway, please feel free to end the session if you don't have any question regarding the solution
Excelchat Expert
12/04/2018 - 11:21
your rating and feedback after ending the session is greatly appreciated too! hope to see you again!
User
12/04/2018 - 11:21
no problem and thank you very much for your quick support
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.
