Good morning everyone, this is a simple formula that I can't put my finger on
for some reason this morning, but I'd appreciate some help.

I'm trying to track training completions

in Cell A2 I have the total amount of employees.
in Cell B2 I have the amount of employees trained.
in Cell C2 I want the percentage of employees trained. Or the percentage of
employees left to be trained.

Thank you inadvance for you help.

=B2/A2 = percentage of employees trained.

=1-(B2/A2) = employees to be trained.

If A2 = 100 and B2 = 10, then

10/100 = 10% of employees trained

1-(10/100) = 90% of employees to be trained.

Dave
--
Brevity is the soul of wit.


"smiths4" wrote:

Good morning everyone, this is a simple formula that I can't put my finger on
for some reason this morning, but I'd appreciate some help.

I'm trying to track training completions

in Cell A2 I have the total amount of employees.
in Cell B2 I have the amount of employees trained.
in Cell C2 I want the percentage of employees trained. Or the percentage of
employees left to be trained.

Thank you inadvance for you help.

In C2,
For % trained:
=B2/A2%

For % to be trained:
=(A2-B2)/A2%

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"smiths4" wrote in message
...
Good morning everyone, this is a simple formula that I can't put my finger
on
for some reason this morning, but I'd appreciate some help.

I'm trying to track training completions

in Cell A2 I have the total amount of employees.
in Cell B2 I have the amount of employees trained.
in Cell C2 I want the percentage of employees trained. Or the percentage of
employees left to be trained.

Thank you inadvance for you help.

Thank you Dave it worked like a charm.

"Dave F" wrote:

=B2/A2 = percentage of employees trained.

=1-(B2/A2) = employees to be trained.

If A2 = 100 and B2 = 10, then

10/100 = 10% of employees trained

1-(10/100) = 90% of employees to be trained.

Dave
--
Brevity is the soul of wit.


"smiths4" wrote:

Good morning everyone, this is a simple formula that I can't put my finger on
for some reason this morning, but I'd appreciate some help.

I'm trying to track training completions

in Cell A2 I have the total amount of employees.
in Cell B2 I have the amount of employees trained.
in Cell C2 I want the percentage of employees trained. Or the percentage of
employees left to be trained.

Thank you inadvance for you help.