Ratio Help

[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

 

[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

 

[Jason Morin]

Here are 2 ways:

http://j-walk.com/ss/excel/usertips/tip81.htm

HTH
Jason
Atlanta, GA

 

[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,

 

[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)