Percent of
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.
|