Ratio Help

E

ecugrad

I'm trying to figure out a ratio, basically the number of managers t
employees in my organization in each department. I want the end resul
to be in a form of: example( 15:1 or 10:1) so on. I have the count o
each group from each department, but can't seem to automate the ratio

Thanks,

Mik
 
D

DNF Karran

The easiest way would be =[CountofManagers] divided b
[CountofEmployees] so you could then use the figures in calculatio
later. However, I guess you want the numbers to be in the format "15:1
if so you need:

=[CountofManagers]&":"& [CountofEmployees]

Dunca
 
A

Alan

With the employees in A1 and the Managers in B1
=A1/B1&":"&1
or to round up or down avoiding decimal places,
=ROUND(A2/B2,0)&":"&1
Regards,
 
J

JE McGimpsey

One way:

Assume mangers in A1, employees in A2:


A3: =A2/A1

Format A3 with Format/Cells/Number/Custom 0":1" (or 0.0":1", etc)
 
Top