Percent of

[Guest]

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.

 

[Guest]

=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

 

[RagDyeR]

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!
=====================================================

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.

 

[Guest]

Thank you Dave it worked like a charm.

=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