Ratio Function

[Samantha0310]

Hello.
Ok, I am looking to have a ratio that pretty much describes how many office
personnel there are to how many shop employees there are.

So in my worksheet, I want the ratio to show up as - 1:3.35

Here is my information:

In E24 I have 67 (shop employees) and in E39 I have 20 (office employees).
What is the formula I would use?

Thank you so much!

 

[Bernie Deitrick]

Samantha,

="1:"&TEXT(E24/E39,"0.00")

HTH,
Bernie
MS Excel MVP

 

[T. Valko]

Try this:

="1:"&ROUND(E24/E39,2)

Note that this results in a TEXT string.