**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.*